Workbook not caculating formulas

R

RodShaw2

I have had this problem before and fixed it but I am drawing a blank.
None of the formulas in my workbook will caculate until it is saved and
closed or the user hits F9. (The user dropped a book on his keyboard and
toggled something). I went into TOOLS-OPTIONS_ CACULATIONS and Automatic
is chosen but it still isn't doing it. Any ideas suggestions? I know it
will be something easy but I can't remember it.

Thanks,

Rod
 
D

Dave Peterson

I've never seen this problem.

But I've seen posts that describe this.

I'd select all the worksheets (rightclick on a tab and choose Select all sheets
then select A1 (just so a single cell is selected
edit|Replace
what: =
with: =
replace all

then ungroup the sheets
 
R

RodShaw2

Sorry I should have been a bit more clear. None of the workbooks o
worksheets on that computer will automatically caculate
 
D

Dave Peterson

Excel determines the calculation mode from the first workbook opened in that
session.

It sounds like you may have changed it once and expected it to stay set that way
forever.

I'd open a workbook and check that calculation setting once more.
 
Top