| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations done in Excel 2000 don't work in Excel 2003
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculations done in Excel 2000 don't work in Excel 2003
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 "Millie" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculations done in Excel 2000 don't work in Excel 2003
What are UDFs?
"Niek Otten" wrote: 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 "Millie" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculations done in Excel 2000 don't work in Excel 2003
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 "Millie" wrote in message ... What are UDFs? "Niek Otten" wrote: 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 "Millie" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 to 2003 update links doesn't work properly any suggest | Excel Worksheet Functions | |||
| Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Linear Mode
