turn automatic calculation off forever!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

schouwla@yahoo.com - 01 Sep 2005 01:45 GMT

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

Reply to this Message

Dave Peterson - 01 Sep 2005 02:03 GMT

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.

> I want to turn off automatic calculation for all new Excel sessions I
> open.
[quoted text clipped - 14 lines]
> Regards
> Lars Schouw

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 01 Sep 2005 02:03 GMT

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

> I want to turn off automatic calculation for all new Excel sessions I
> open.
[quoted text clipped - 14 lines]
> Regards
> Lars Schouw

Signature

Dave Peterson

Reply to this Message

schouw@gmail.com - 02 Sep 2005 03:05 GMT

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

Reply to this Message

schouwla@yahoo.com - 02 Sep 2005 03:06 GMT

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

Reply to this Message

Dave Peterson - 02 Sep 2005 05:26 GMT

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

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

Signature

Dave Peterson

Reply to this Message