Calculation error on one PC only

[rewb2]

I have Excel 2007 at my work, and we produce reasonably simple
financial models, which involve a worksheet of input hard-coded
numbers, a worksheet of calculations (which rarely get much more
complicated than adding, multiplying, dividing, a few MIN and MAX
etc), and a summary sheet with a few data tables.

One of our spreadsheets produces odd results when opened on one of our
PCs (a desktop that's a few years old but still reasonable-ish spec).
One calculation in the model is "=J152/J154", where J152 might be 100,
say, and J154 might be 1.5. Excel calculates this incorrectly,
showing 75, say, rather than the 66.7 you would expect. This only
happens on the desktop, and it takes about a second from opening
(feels like calculation time, bearing in mind the data tables) to come
up with the incorrect answers, originally showing the correct answers
as would be shown on our other PCs.

If you re-enter the formula (e.g. select cell, press F2, press enter)
then the correct answer is given - it doesn't revert back to the
incorrect answer upon recalculation. The spreadsheet has no macros or
external links, does not appear to have any circular references, and
works fine on all other computers.

Was wondering if anyone had come across this before, and if there are
any solutions / diagnosis?

 

[Billy Liddel]

Will pressing F9 (calculate) work? If so enter this macro in the Workbook
module

Private Sub Workbook_Open()
Worksheets("Sheet1").UsedRange.Calculate
End Sub

Change the sheet name to suit

Peter

 

[rewb2]

Pressing F9 doesn't do anything. As I say, it seems to only start
producing the wrong answer once it's had a chance to calculate (I can
see the correct numbers in the spreadsheet for about a second, before
they change to the incorrect ones).

 

[Dave Peterson]

You may want to try this if calculation is already set to automatic:

Select all the cells
Edit|Replace (or whereever it is in xl2007!)
what: = (equal sign)
with: =
replace all

It should force excel to reevaluate all the formulas--and maybe it'll wake
excel's calculation engine.