Certain cells won't recalculate unless Save As is chosen

cdiffell

New Member
Joined
Mar 14, 2002
Messages
46
I have a spreadsheet with about 30 tabs, all of which are linked together with formulas. There are also a bunch of Hyperion Retrieve formulas. The workbook is our financials for the board of directors. As part of the setup, I need to go in and manually move tabs around (no tabs are added or deleted). When I do this, some of my formulas that reference data on other sheets do not update, no matter what, unless I manually edit the cell or select Save - As (Save by itself does not work either). Even pressing CTRL + SHIFT + F9 does not work. Has anyone ever run into this before? It only happens when I move groups of sheets around in the workbook.

Thanks,
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
Click on Tools- Option and Calculation. Do you have Calculation set to Manual and the Recalculate Before Save box checked? If so, click the Automatic option or try pressing CTRL-ALT-F9 or CTRL-SHIFT-ALT-F9 and see if that works. If not, then I'm stumped.
 

cdiffell

New Member
Joined
Mar 14, 2002
Messages
46
The calc is not set to manual. and ctrl shift f9 does not work either. The worksheet is about 5 MEGs, so I wonder if, in moving all the sheets around, it just freezes up somehow?

It's weird. At least Save As works.
 

GeorgeB

Board Regular
Joined
Feb 16, 2002
Messages
239
This is a wel know bug in Excel. Microsoft claims to be working on it but so far no fix.
It usually happens with large workbooks with many links in it. We usually don't see it untill the workbook gets over 10 meg. Keep your eyes open.
 

Forum statistics

Threads
1,144,151
Messages
5,722,801
Members
422,459
Latest member
Chriselff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top