Formula not working

  • Thread starter Thread starter acheng
  • Start date Start date
A

acheng

My application contains 10 workbooks which are formula-
linked. It worked perfect in my old Dell. When mulitple
applications are run at the same time in my new IBM, the
formula (not all) even in the same workbook do not get
updated on change of another cell value. I've tried Edit-
Link-Update Value, Shift F9/F9, change calculation
method, turn off and on the laptop, copy those
likely "corrupted" file to another computer, reinstall
Office 2002, etc. It won't solve the problem. Only when
I do F2 and hit enter, the formula cell get updated. I
have IBM R32 in XP SP1 and Office XP running in 1GM RAM
environment.
 
I have experienced the same issue. #values is cells that contain a simple
reference to another cell without an error. I created the spreadsheet on the
same computer, so there has been no change in hardware. In addition to
acheng's attempts, I've restarted the computer (to address memory issues) and
chosen to calculate both with and without iterative calculations (in case I
have a circular reference anywhere). None of these things helped.

The workaround that I _have_ found is to save it to another filename. Once
saved, the workbook immediately recalculates correctly and all the #Value
errors disappear.

Lovely, but why the error? suggestions anyone?
 
Back
Top