Excel in Office 2007 does not do an automatic recalculate

[David]

I have Office 2007 on my Win/XP workstation. I have apparently (in
error) changed a setting.

For one specific worksheet, Excel no longer automatically recalculates
when I change cell contents.

For all other worksheets, Excel does recalculate automatically.

I'd sure appreciate some advice to fix the one worksheet that does not
auto recalculate.

Thanks

 

[Jim Rech]

Unless this is a bug I haven't heard about, there is only one way that a
sheet will not calculate when it otherwise should and that is if its
'EnableCalculation' property has been set to False. The only problem with
this answer is that it is highly unlikely you would have stumbled onto this
setting, set it, and then entered a fugue state and forgotten all about it.

Anyway, to check this setting:
1. Right click on the worksheet's tab and pick View Code.
2. Press F4 to open the Properties window for this sheet.
3. Check/change the EnableCalculation property.

Say, there is no chance that you accidentally replaced all the formulas with
their values, right (Like with a Copy/Paste Special,Values)? There are
still formulas on the sheet?

 

[Bob Flanagan]

David, are there a lot (temendous number) of formulas in your workbook?
Excel may be stopping calculation as as a result.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[David]

I must admit the problem was a personal screw-up. I am very used to
the older Office menus. I have recently upgraded to Office 2007 from
many years using the older menu system. I still have hard times
finding things on the new-fangled menus. But, I am improving.

From the formulas menu, then calculation, then calculation options, I
found I had the setting as manual. I have changed this to automatic &
everything is now ok.

In the main Excel options, I had thought I had calculation as
automatic. You suggestions below let me know where the fault was.
Thanks.

 

[David]

I have a large number of tab (10 or so) in the worksheet. Each tab is
an attendance sheet for a specific classroom in my day care. I added
one additional tab where I actually change the date. Each classroom
tab references the "main date change tab". It makes things easier.

Do you know of an easy way to find a menu entry if you are not very
familiar with the new menu system? I thought Microsoft might have a
cross-reference chart or something similar, but I can't find it.

 

[Gord Dibben]

David

Ron de Bruin has placed much info on his website showing where the menu commands
for 2007 are located.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

 

[Roger Govier]

Hi

It is possible to customise the ribbon yourself, and add a Tab with all
of the old Menu features.
There are some sites with information on how to achieve this
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm
http://www.nickhodge.co.uk/2007files/customiseribbon.htm
http://pschmid.net/index.php


or if you don't want to do it yourself there is a free download from
Shah Shailesh which works very well
http://in.geocities.com/shahshaileshs/
choose Excel Menu 2003

--
Regards


Roger Govier