Links Not Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 laptops).

- 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 seen solutions to force the
links to work but I'm more concerned with what's causing the problem. I've
used linking extinsively in the past and have never encountered this before,
although I've seen numerous posts on this board as well as other in regards
to it. 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.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...bceee60&dg=microsoft.public.excel.crashesgpfs
 
I am also experiencing this problem. Does anyone have any ideas --
workarounds or (even better) a fix?
 
I am also experiencing this sporadic problem in Excel 2000. Has there been an
explanation?

Jerry
 
I'm using Excel 2003. From the Online Help:

Press F9: Calculates formulas that have changed since the last calculation,
and formulas dependent on them, in all open workbooks. If a workbook is set
for automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9: Calculates formulas that have changed since the last
calculation, and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9: Calculates all formulas in all open workbooks,
regardless of whether they have changed since last time or not.

Press CTRL+SHIFT+ALT+F9: Rechecks dependent formulas, and then calculates
all formulas in all open workbooks, regardless of whether they have changed
since last time or not.
 
I was hoping for an automatic repair. Since this is so infrequent it is too
easy for someone to forget the CTL+ALT+F9 on a bid.

Thanks for the help.
Jerry
 
As soon as I had a file which would replicate the error, I had it
professionally reviewed. Certain cells did not recalculate properly in any
version of excel, even the version being tested for release. What was termed
as a "sloppy work-around" was to add +(0*NOW()) at the end of a formula in
any cell which is not updating properly. Excel will always recalculate a cell
with NOW() in it. It appears sometimes excel, in error, doesn't think the
cell should be re-calculated. Remember, only the cell with NOW() is sure to
be re-calculated, any other cells are up to excel's disgretion.

Jerry
 
Back
Top