Reset workbook back to Auto Calculate

[Karl_S]

Hello,

I have a workbook that is opening in a Manual Calculate mode. I want it to
open in Automatic mode. It is the first workbook I open, and the empty one
that opens when I first start Excel is in Automatic mode. Even though I
change the mode to Automatic in the workbook and save it, it keeps defaulting
to Manual. Others come up Automatic, and I know I could open a workbook I
don't need opened and then open the one I do need just to force it to
Automatic, but that is not the answer. I need to know how to make this
workbook open in Automatic Calculation mode when it is the first one opened.
What am I missing?

 

[Mike H]

Hi,

You may have something in the workbook_open event changing calculation to
manual, have a look.

ALT+F11 to on VB editor. Double click 'ThisWorkbook' and have a look what
you have on the right hand side

Mike

 

[Karl_S]

Nope. Nothing in there:

Private Sub Workbook_Open()

End Sub


But I do appreciate the reply.

 

[Dave Peterson]

I'm guessing that your personal.xls file was saved in manual mode. And when
that opens, it tells excel how to toggle that setting.

I'd unhide the personal.xls workbook.
Change the setting to automatic.
Hide the personal.xls workbook.
Close excel and answer yes to the "do you want to save your changes" prompt.

Then close excel and restart to test.

In xl2003 menus, you can use:
Window|unhide
to unhide those hidden workbook windows.

 

[Karl_S]

Thank you for the reply. Unfortunalty I do not beliece I have a
personal.xls. I searched the hard drive for personal.xls and found none. I
went into Excel, opened a new workbook, and it was set to automatically
update. When I first go in, the blank workbook is set to automatically
update. Other existing workbooks open to auto update. In the View tab,
under Window, the Unhide is greyed out.

 

[Dave Peterson]

Close excel
Search for XLStart (it's a folder).

Maybe you have a workbook (including personal.xls) in that folder.

Sometimes those other folders can be hard to find.

Maybe you can use an old DOS command.

close excel
shell to DOS
windows start button|Run
cmd (windows 2k/xp)
command (windows 98)

At the DOS prompt:
C: (to get to the C: drive)
cd\ (to get to the root directory)

dir xlstart /s

the /s means to search through subdirectories.

Make a note of the location(s) you find and check there.

 

[Karl_S]

Sorry Dave, but there are only 2 XLStart folders on the computer and both are
empty. Not even any hidden files.

Karl

 

[Dave Peterson]

I don't have any other guesses.

Sorry Dave, but there are only 2 XLStart folders on the computer and both are
empty. Not even any hidden files.

Karl

 

[Karl_S]

Dave,

No problem. I do appreciate the help.

Enjoy your weekend!

Karl