Re-calculation

R

Robin Clay

Greetings !

Suddenly, Excel has started
playing up.

When I press F9 to start
calculating, Excel sets every
Cell holding a formula to #NAME?

Consequently, nothing will calculate !

It works just FINE if I run through the
file pressing F2 and Enter for each cell.

I have tried copying all the sheets
and the VBA code into a new Book,
to try to cure what might be a "corrupted" file.

I have noticed that the Calculate
function has seemed a tad unpredictable.


RClay AT haswell DOT com
 
D

Dave Peterson

Just guesses:

Do you have any UserDefinedFunctions in your workbook?

Are they calculating correctly--or is there an error in the code?

How about range names? Any conflicting with UDF names/builtin function names???
 
Top