Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 12th 05, 01:17 PM
Hoochi Coochi Man
 
Posts: n/a
Default links not updating although autocalc is On?

Hi
My very large workbook has developed a strange problem that cell references
from one sheet to another have stopped updating. e.g. if data is entered on
one sheet it will not update linked cells in other sheets. Stragely, if I
recreate the link - which is precisely the same- it works once but then
becomes 'frozen' and will not update if the data is changed.
Would be grateful if someone could help me remove this critical spanner from
my works.
Thanks
Keith

  #2   Report Post  
Old January 13th 05, 12:09 AM
Dave Peterson
 
Posts: n/a
Default

maybe, just maybe, if you do:

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

it'll wake excel up and your calculations will be ok again.

Post back with your results. This seems to be an infrequent problem, but it
would nice to know if that suggestion works.

Hoochi Coochi Man wrote:

Hi
My very large workbook has developed a strange problem that cell references
from one sheet to another have stopped updating. e.g. if data is entered on
one sheet it will not update linked cells in other sheets. Stragely, if I
recreate the link - which is precisely the same- it works once but then
becomes 'frozen' and will not update if the data is changed.
Would be grateful if someone could help me remove this critical spanner from
my works.
Thanks
Keith


--

Dave Peterson
  #3   Report Post  
Old January 13th 05, 11:33 AM
Hoochi Coochi Man
 
Posts: n/a
Default

Hi Dave

Yes, it did work so many thanks for the tip. I found that Ctl Alt F9 also
worked but only forced a recalc then the sheets 'frooze' again. Your solution
seems to be holding up so far.
Cheers
Keith

"Dave Peterson" wrote:

maybe, just maybe, if you do:

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

it'll wake excel up and your calculations will be ok again.

Post back with your results. This seems to be an infrequent problem, but it
would nice to know if that suggestion works.

Hoochi Coochi Man wrote:

Hi
My very large workbook has developed a strange problem that cell references
from one sheet to another have stopped updating. e.g. if data is entered on
one sheet it will not update linked cells in other sheets. Stragely, if I
recreate the link - which is precisely the same- it works once but then
becomes 'frozen' and will not update if the data is changed.
Would be grateful if someone could help me remove this critical spanner from
my works.
Thanks
Keith


--

Dave Peterson

  #4   Report Post  
Old January 14th 05, 12:04 AM
Dave Peterson
 
Posts: n/a
Default

Thanks for the info.

Now google knows that it's working for you (at least for awhile!).

Hoochi Coochi Man wrote:

Hi Dave

Yes, it did work so many thanks for the tip. I found that Ctl Alt F9 also
worked but only forced a recalc then the sheets 'frooze' again. Your solution
seems to be holding up so far.
Cheers
Keith

"Dave Peterson" wrote:

maybe, just maybe, if you do:

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

it'll wake excel up and your calculations will be ok again.

Post back with your results. This seems to be an infrequent problem, but it
would nice to know if that suggestion works.

Hoochi Coochi Man wrote:

Hi
My very large workbook has developed a strange problem that cell references
from one sheet to another have stopped updating. e.g. if data is entered on
one sheet it will not update linked cells in other sheets. Stragely, if I
recreate the link - which is precisely the same- it works once but then
becomes 'frozen' and will not update if the data is changed.
Would be grateful if someone could help me remove this critical spanner from
my works.
Thanks
Keith


--

Dave Peterson


--

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
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM
How to find cells with links to other workbooks? Bathonian Excel Discussion (Misc queries) 1 December 21st 04 09:55 AM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 03:17 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 09:27 PM


All times are GMT +1. The time now is 10:36 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