software

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.

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?

--
Kind regards,

Niek Otten

quot;Milliequot; gt; wrote in message
...
gt;I have calculations that I did in an Excel 2000 worksheet. When I open the
gt; sheet in Excel 2003, the calculations don't update. I have them set to
gt; automatically calculate.
What are UDFs?

quot;Niek Ottenquot; wrote:

gt; First, no matter how you set the calculation in Excel2000, they may be
gt; different in Excel 2003. Check after you load the workbook, before you
gt; calculate.
gt;
gt; Then try forcing a rebuild of the dependency tree:
gt;
gt; CTRL ALT SHIFT F9
gt;
gt; Any UDF's?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Milliequot; gt; wrote in message
gt; ...
gt; gt;I have calculations that I did in an Excel 2000 worksheet. When I open the
gt; gt; sheet in Excel 2003, the calculations don't update. I have them set to
gt; gt; automatically calculate.
gt;
gt;
gt;

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?

--
Kind regards,

Niek Otten

quot;Milliequot; gt; wrote in message ...
gt; What are UDFs?
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; First, no matter how you set the calculation in Excel2000, they may be
gt;gt; different in Excel 2003. Check after you load the workbook, before you
gt;gt; calculate.
gt;gt;
gt;gt; Then try forcing a rebuild of the dependency tree:
gt;gt;
gt;gt; CTRL ALT SHIFT F9
gt;gt;
gt;gt; Any UDF's?
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Milliequot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have calculations that I did in an Excel 2000 worksheet. When I open the
gt;gt; gt; sheet in Excel 2003, the calculations don't update. I have them set to
gt;gt; gt; automatically calculate.
gt;gt;
gt;gt;
gt;gt;