Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 7th 05, 01:13 AM
djm023
 
Posts: n/a
Default ?? Links Not Updating ??

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.

  #2   Report Post  
Old September 7th 05, 01:17 AM
sdosborne
 
Posts: n/a
Default

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.

  #3   Report Post  
Old September 7th 05, 02:16 AM
Dave Peterson
 
Posts: n/a
Default

I've never seen excel do this (with calculation set to automatic). But there
have been a few posts that describe the same situation.

You may want to try this...

select all the worksheets
select all the cells (ctrl-a, twice in xl2003)
edit|replace
what: =
with: =
replace all

Maybe it'll wake up excel's calculation engine.

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.


--

Dave Peterson
  #4   Report Post  
Old September 7th 05, 02:10 PM
djm023
 
Posts: n/a
Default

Thanks for the fix Dave.

The main thing that worries me is the instances where the problem is
occuring and it goes unnoticed (let's face it, we always assume a direct link
will update!). I've seen posts on this board as well as others describing
this issue but I haven't come across a reason for the problem occuring in the
first place.

Scott,

The hardware/software we've experienced this issue on varies. The following
is my computer:

Dell Latitude 400
Microsoft Windows XP Professional 2002
1.59 GHz Intem Pentium M
1.50GB RAM (upgrade)

Not sure if there's a connection to be found there.


"Dave Peterson" wrote:

I've never seen excel do this (with calculation set to automatic). But there
have been a few posts that describe the same situation.

You may want to try this...

select all the worksheets
select all the cells (ctrl-a, twice in xl2003)
edit|replace
what: =
with: =
replace all

Maybe it'll wake up excel's calculation engine.

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.


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM
Updating Links Doug Excel Worksheet Functions 0 February 16th 05 05:21 PM
links not updating although autocalc is On? Hoochi Coochi Man Excel Discussion (Misc queries) 3 January 14th 05 12:04 AM
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 03:17 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017