Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 05, 05:24 AM
Don Holmes
 
Posts: n/a
Default "Pastelink" cells not updating

I'm using Excel 2000 and have a workbook with several worksheets. I have a worksheet that summarizes data from the others and to do so I have many cells in it that are simply links to other cells on other sheets. This evening I added a few more sheets with various data items and now many of the "linked" cells simply do not update when I make changes to the cell it's linked too. Very strange. It's as if there is an "update cell" function that simply isn't happening. The auto calculate option is turned on and I've done manual calculations as well - no good.

Any ideas?

Thanks, Don

--


  #2   Report Post  
Old February 6th 05, 05:41 PM
Bill Manville
 
Posts: n/a
Default

Early builds of Excel 2000 had some problems losing track of the
formulas that needed to be calculated. I suggest you use OfficeUpdate
to get up to the latest version.

Then try Ctrl+Alt+F9 which does a complete calculation pass.

If there are still problems try, on each sheet,
Edit / Replace / = (with) =


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Old February 6th 05, 11:27 PM
Don Holmes
 
Posts: n/a
Default

Thanks. I'm pretty good about making sure I have the latest updates but I'll certainly check again. Does the problem not exist in subsequent versions of Excel? If not, I may just upgrade. Alternatively, I'll try your suggestion. If I read it correct you're suggestion is to simply do a sheet-for-sheet replace-all "=" with "=" (i.e., touching every cell which has a formula but not changing anything)? Since I have 30-40 sheets that'll be fun...

THx again.

--

"Bill Manville" wrote in message ...
Early builds of Excel 2000 had some problems losing track of the
formulas that needed to be calculated. I suggest you use OfficeUpdate
to get up to the latest version.

Then try Ctrl+Alt+F9 which does a complete calculation pass.

If there are still problems try, on each sheet,
Edit / Replace / = (with) =


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #4   Report Post  
Old February 7th 05, 11:22 PM
Don Holmes
 
Posts: n/a
Default

Hello Bill -

Well I checked and indeed I was current with regard to Excel updates... For context purposes I'll explain that I have many very simple "data" sheets, there are about 50 worksheets in this workbook, about half of which are currently hidden.

This morning I shut down Excel (and all three of the other workbooks I had opened) and rebooted the machine. I then went into the offending workbook and copied a couple sheet's worth of data and pasted it in-place as "values only" since I no longer needed the formulas anyway (and I had read about a 65K autocalc limit of formulas/links). Best I can tell (without going and verifying each and every cell's calculation now) it appears that the workbook auto calculation is now working... But, what caused it is unclear.

I don't know if it had to do with shutting down the other multiple workbooks (and potentially a single thread issue in Excel), copying some of the sheets over themselves as "values only", or even the reboot. Of course now I'm very skeptical about my trust in the workbook any longer as I don't know what caused the problems (or what fixed it frankly). Had I not accidentally noticed some figures not updating I could have missed this for some time...

With regard to your suggestion below do you know of a way to access all 50 sheets (both hidden and not) without having to manually unhide and go to each to run the replace function? Argh...

Thanks, Don

PS: By the way, I did a simple calculation and I'd be surprised if there is over 10,000 calculations, much less the advertised limit of 65,536 before Excel tries to recalc every cell in the workbook... It doesn't seem at all likely that it is the "65k calc's issue" shown in the knowledge base...

--

"Bill Manville" wrote in message ...
Early builds of Excel 2000 had some problems losing track of the
formulas that needed to be calculated. I suggest you use OfficeUpdate
to get up to the latest version.

Then try Ctrl+Alt+F9 which does a complete calculation pass.

If there are still problems try, on each sheet,
Edit / Replace / = (with) =


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



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
Module updating of Protected Cells GaryByrd Excel Discussion (Misc queries) 1 February 3rd 05 06:23 PM
Locked cells not updating Jamie Excel Worksheet Functions 0 February 2nd 05 06:49 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Excel 2003 isn't updating my cells [email protected] Excel Worksheet Functions 7 November 5th 04 05:05 PM


All times are GMT +1. The time now is 03:07 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017