Calculations done in Excel 2000 don't work in Excel 2003

M

Millie

I have calculations that I did in an Excel 2000 worksheet. When I open the
sheet in Excel 2003, the calculations don't update. I have them set to
automatically calculate.
 
N

Niek Otten

First, no matter how you set the calculation in Excel2000, they may be
different in Excel 2003. Check after you load the workbook, before you
calculate.

Then try forcing a rebuild of the dependency tree:

CTRL+ALT+SHIFT+F9

Any UDF's?
 
M

Millie

What are UDFs?

Niek Otten said:
First, no matter how you set the calculation in Excel2000, they may be
different in Excel 2003. Check after you load the workbook, before you
calculate.

Then try forcing a rebuild of the dependency tree:

CTRL+ALT+SHIFT+F9

Any UDF's?
Click to expand...
 
N

Niek Otten

User Defined Functions. If you developed the workbook yourself and don't know about UDF's, then there aren't any.

Did you check the setting as I advised? Did
CTRL+ALT+SHIFT+F9
help?
 
Top