Preventing re-calculation of formulas

[stoneglobe]

Hi

Was wondering if anyone has any ideas on this one.

I have a monthly report that has to be completed on a daily basis using data exported form another program.

Is there a way to prevent excel from re-calculating a formula if the value of that formula is greater than 0.

Basically I want to be able to drop the exported data into the same place on a worksheet each morning and have the rest of the worksheets automatically calculate from this data based on dates being the same. Currently the only way I know how to do this is using a sumif to match the date on the exported data to the date required in the rest of the workbook. Problem is when the next data is exported the previous day recalculates back to 0 as the date is no longer recognised.

Any help on this would be greatly appreciated.

Thanks

Dan

[DonkeyOte]

sounds to me as though you need to think about overwriting the formulae with the values for historic dates -- you can theoretically do what you want utilising iterative calculations but this would not be advised.

[Richard Schollar]

Hi

A possible alternative would be to switch the workbook to Iteration mode (max number of iterations 1) and change your formulas to:

=IF(A1>0,A1,YourPreviousFormulaHere)

assuming the above was entered in A1 (so you effectively create a circular reference).

Richard

[stoneglobe]

Hi

A possible alternative would be to switch the workbook to Iteration mode (max number of iterations 1) and change your formulas to:

=IF(A1>0,A1,YourPreviousFormulaHere)

assuming the above was entered in A1 (so you effectively create a circular reference).

Richard

Hi Richard

That sorted it out for me.

Cheers

Dan