my personal.xls file is causing problems

[Guest]

everytime I open 2 work books the second one opens and warns me that
personal.xls is locked for editing by myself. I don't currently have any
macros that I want available to all my workbooks. Is there anyway to
deactive this as I often need to have multiple workbooks open at the same
time.

 

[Guest]

Chrisinct,

I get the same as you, if you're sure there's nothing in the personal.xls
that you need anymore you can simply delete it. I did a "Search" to locate
the file, which was in the "Documents and Settings" folder (in XP) under my
log-in name, there were a few personal.xls files found so I made sure it was
mine before pressing the delete button. I then started Excel twice and
didn't get the error message. Unfortunately for me I've loads of macros I
use so I can't leave my personal.xls deleted and so continue to put up with
the message!

Hope this of help to you though.

 

[Dave Peterson]

If you open both files in the same instance of excel, you won't have this
trouble.

If you open the file by double clicking on it in windows explorer, you may want
to try this so that the second file opens in the same instance.

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe one of these will work for you.