Reset workbook back to Auto Calculate

K

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?
 
M

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
 
K

Karl_S

Nope. Nothing in there:

Private Sub Workbook_Open()

End Sub


But I do appreciate the reply.
 
D

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.
 
K

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.
 
D

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.
 
K

Karl_S

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

Karl
 
D

Dave Peterson

I don't have any other guesses.

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

Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top