Strange Office XP calculations from 2003

  • Thread starter Thread starter manual2k
  • Start date Start date
M

manual2k

I have a linked spread sheet with ALOT of accounts data..now I made
some changes(In XP) and saved them...this took the total amount from
29,000.000 to 31,000,000. Now, thats fine if I open it in XP. HOWEVER!
If I open it in 2003, I see the 31 million part, I can either click
Update or Not Update links..either way I get taken BACK to the 29
million version.

Any ideas what causes this fault?

It works perfectly well on all Office XP machines, soon as its fired
up in 2003 it reverts back to the old version :S
 
Manual,

Excel seems to have some bugs yet still in its calculation machine. Try
pressing F9 (Calculate all) or Ctrl-Shift-F9 (Calculate full, which
calculates all open workbooks). If you're using the INDIRECT() function in
any of your formulas, it won't work with workbooks that aren't open.
 
You must log in or register to reply here.

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

Nexus 7 Update 3
Libre Office 5
Disable Microsoft Office File Validation 5
Office 2003 on Win7 Pro - also XP 10
Office 2003 Excel calculation is slow? 4
FP 2003 won't load with Office 2007 1
Problem using more than 1 Excel version on same workbook? 2
Opening excel 2007 document in excel 2003 3

Back
Top