Excel Making Me Nervous

[William Benson]

Excel 2003...

Recently, each time I shut down Excel it asked me if I wanted to save
changes to Personal.XLS. Trouble was, I hadn't done anything to
Personal.xls! It would happen even if I just opened Excel and closed it
without doing anything at all. Finally I answered 'Yes' just to make the
message go away, and it did.

How can "changes" be held in abeyance *in between* Excel sessions?! Maybe
the some feature of Auto-recovery which was carrying forward session by
session until I dispensed with the recovered version or else allowed it to
save over the pre-existing version?

Also, some time ago I turned off Save AutoRecover Info. Well, thereafter I
had a crash ... and sure enough, on restarting Excel, I was asked what I
wanted to do with certain files. I assumed these were files open at the time
Excel crashed, but now I am wondering if they were files that had been being
kept up until that point in time? ... Like, did turning off 'Save
AutoRecover Info' maybe put them into suspended animation, awaiting the next
crash? Seems wierd, really. If there is a write-up on Autorecover, I would
like to read about it, thanks. Seems worth understanding completely.

Any ideas without bending anyone's brain too far?

 

[Anne Troy]

Hi, Bill. I want to know why I sometimes open Excel and my personal.xls
file is "in use". But I never wanted to know bad enough to ask...it just
started happening about a week ago. Anyway, I'll sit in here with you...
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Piranha]

Willam,
Do you have a Macro in the Personal.xls that runs on Excell opening?
The personal.xls should not be "Closed" (IE: clicking "X") it should be
"Hidden"
then on exiting Excel, click Ok Save and that should stop it from
acting that way.
As it will open as a hidden sheet.
Dave

 

[Anne Troy]

Yes, I know how to handle the personal.xls. Nope. There's nothing but a
straight sub in there.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[William Benson]

No. It is always hidden, never closed.

Willam,
Do you have a Macro in the Personal.xls that runs on Excell opening?
The personal.xls should not be "Closed" (IE: clicking "X") it should be
"Hidden"
then on exiting Excel, click Ok Save and that should stop it from
acting that way.
As it will open as a hidden sheet.
Dave

 

[William Benson]

Sometimes Personal.XLS being in use is an indicator that you have a hidden
instance of Excel running in the background. Maybe some code made it
invisible, or a "crash" just caused the window to go away, but the
application didn't shut down.

This can be demonstrated by typing in Immediate pane: "application.Visible =
False"

Excel disappears from task bar and screen, (leaving VB editor which is a
separate application). If you list the processes using Task Manager, you
will see Excel.exe, and if you click Excel Icon in Start Menu you will get a
message about Personal.xls being in use.

Note: Remember to retype application.Visible = true BEFORE shutting down VB
Editor, or else you will have to use the Task Manager to kill the first
instance of Excel. Typing application.Visible = true into the instance of VB
Editor that you open the second time will not have an impact on the first
instance of the Excel Application.

Maybe hunt through all code you have been running for application.Visible =
False

Good luck.