Re-calculation

  • Thread starter Thread starter Robin Clay
  • Start date Start date
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
 
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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas not calculating - Calculation is on Automatic & I pressed 2
Cells not calculating until f2 is used to edit cell 4
calculation 2
Manual calculation does not work 3
auto calculate not working 1
Cells Not Calculating - Calc Option Selected 2
My Excel file is not calculating! 13
Copying files 2

Back
Top