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
|