turn automatic calculation off forever!

S

schouwla

I want to turn off automatic calculation for all new Excel sessions I
open.

When I change the settings and close Exeel the changes are lost in a
new session.

I tried to save a sheet called book1.xls in my xlstartup folder with
calculations set to manual. Close Excel and open a new Excel sesson
remembers the change.
When I open one more Excel sesson it says that the file book1.xls is
locked for editing.

Any ideas?

I am using Excel 2003 and are sometimes using Excel 2000 as well.

Regards
Lars Schouw
 
D

Dave Peterson

I'd open excel
and hide book1.xls (window|hide)

Then close excel and answer yes to the save prompt.

Now open windows explorer
go to your XLStart folder
rightclick on book1.xls, choose properties and make it Readonly
(on the general tab)

Then back to excel and see if you can open multiple instances without any
warnings.
 
D

Dave Peterson

ps. I didn't test this, so please post back.

I want to turn off automatic calculation for all new Excel sessions I
open.

When I change the settings and close Exeel the changes are lost in a
new session.

I tried to save a sheet called book1.xls in my xlstartup folder with
calculations set to manual. Close Excel and open a new Excel sesson
remembers the change.
When I open one more Excel sesson it says that the file book1.xls is
locked for editing.

Any ideas?

I am using Excel 2003 and are sometimes using Excel 2000 as well.

Regards
Lars Schouw
Click to expand...
 
S

schouw

It worked!!
Now I do not get up a blank sheet by startup. Is there anyway I can get
that to work again?
Lars
 
S

schouwla

It worked!!
Now I do not get up a blank sheet by startup. Is there anyway I can get
that to work again?
Lars
 
D

Dave Peterson

Still untested...

Create a new workbook and save it as book.xlt (a template file) in that XLStart
folder.

I'm not sure if it will kill the calculation mode stuff (if it opens first) or
if it will work at all.

Other options...
1. Just click that new icon on the standard toolbar (a little work, but not
too much!)

2. Add this macro to the book1.xls project.
In a general module:

Option Explicit
sub auto_open()
workbooks.add
end sub
 
Top