Change Excel Formulas to Values

Hi everyone,

I work for a company that puts houses up for rent for individuals.
I've created a report in Excel which calulates the rent value per month of a specific year (every month has its own column). In Navision only the monthly value for the contract is mentioned and not the actual value. In a perfect world I should be able to just take this value and place it in every column for every month. Unfortunately we don't live in a perfect world. :D

To give an example: some rent contracts don't start at the first day of the month but halfway through the month: let's say the 15th of January. The column for the first month (January) should be 15/31 times the monthly rent (which is mentioned in Navision) from February on the rent is the complete amount. Let's say again that this contract ends on the 25th of June. The rent for June whould than be 24/30 times the rent.

Anyway, as you see I have to manipulate the Jet Reports results with some Excel formulas. The problem lies in the fact that I and other users use this report to filter the results on multiple criteria (if desired), but due to the heavy load of Excel formulas, Excel always starts auto calculating for a minute or so. I can turn the automatic calculations of, but than my subtotals don't add up.

Long story, but here's my question: is it possible to not only change the Jet Formulas (with the "hide" parameter) to values, but the Excel values aswell?

Thanks for the help.