Has anyone ever seen anything like this, I'd love to get a thorough
explanation of this oddity.. but it does make me question how many times has
excel calculated the wrong result and I've just not noticed!
Workbook called bad.xls
Contains two worksheets "Process Unit Data" and "TAU"
In Process Unit Data in C41 is the formula "=(1210000+599000)/365/0.95"
In TAU in C10 is the formula ='Process Unit Data'!C41
The result in C41 is 5217.02 this is correct
The result in C10 is 3489.55 this is incorrect
This is all the workbook contains
Clicking in the formula bar in C10 and pressing enter results in C10 showing
the correct result of 5217.02 as does saving the workbook with a new name. If
you comapre the bad.xls and the good.xls (i.e once it shows the correct
result) Shows more data in the bad.xls:
Bad.xls (64512 bytes)
Good.xls (63488 bytes)
I've put this down to file corruption... doesn't sound like a major problem
then right... wrong the full spreadsheet (I cut away everything but the two
cells) went out and the error was only picked up by a manual check when the
numbers looked off! How can I trust Excel ever again?! The best bit of this
is stepping through the formula auditing which tels me the correct local
result then puts the wrong number in! I can send you the sheet if you want to
take a look.