We are experiencing a very similar issue. Except, all of our documents were
created with Excel XP (2002). No one has been able to provide me with a
solution yet. I agree with you, this is very scary because we are using the
analysis from Excel to make decision on how to proceed as an organization.
We are experiencing the issue on multiple separate documents and multiple
PC's. Is your problem consistent? Our's is not. The document may work fine
30 times, then one day it decides not to work. Then, it works OK the next 5
times we open it, and then the next 3 times it doesn't work. very sporadic.
Lets see if we can find any similarities:
Win 2K Pro SP4 build 2195, IBM Netvista with 1.8 GHz P4 256 MB. Office
XP Pro installed. Excel 2002 (10.6501.6626) SP3
Scott
"djm023" wrote:
We have a workbook containing multiple worksheets. Inside the workbook there
are links between the worksheets that have stopped updating as well as links
between worksheets that do continue to update. For example:
1) Worksheet A = 'Sheet1!A2'
2) Sheet1 Cell A2 is changed from $50 to $100
3) Worksheet A will continue to show $50
This is a scarey problem and the second time in the past month it's occured
(different workbooks, different lapops).
- Automatic calculation has been enabled.
- This is a stand alone workbook that does not link to other workbooks.
- This file was created in Excel 2003
Any ideas what's causing the problem? I've used linking extinsively in the
past and have never encountered this before. This harms the integrity of all
excel generated analysis if we're never sure the information is driven by the
most current inputs.
Thanks in adavance.
|