Personal.xls won't start automatically

[Shatin]

My understanding is that the personal.xls is supposed to open at start up
automatically. Don't know why but my doesn't. It's placed in this directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and put
the above path into the textbox. Still the same result, personal.xls just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

 

[Ken Wright]

Personal.xls is a hidden worksheet, so take a look at Window / Unhide and see if
it is there.

You usually store bits of macro code and other snippets in there, but leave it
hidden as a general rule.

 

[Bob Phillips]

Shatin,

Are you sure it is not just hidden.

Goto Window>Unhide and see if it is there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Shatin]

Ken and Bob,

No, the personal.xls is not hidden. It's just not opened automatically. I
use the file all the time and so have unhidden it, it's just that I have to
open the file manually. And even when I hide personal.xls, the file will
still not open.

What is strange is that, I just used Rob Bovey's VBA Documentor to document
the personal.xls. A report file was generated and put into the Xlstart
directory. This report file does open automatically. It's just the
personal.xls that refuses to open.

 

[Dave Peterson]

If it really isn't opening (after you've checked for a hidden workbook), try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are damaged.
And it's easy to just click on "yes" to the "do you want the offending workbook
disabled".

But if excel was really correct that your workbook is damaged, you may have to
use your backup copy.

 

[Bob Phillips]

aah yes, the backups. I'll just get my off-site backups now <vbg>

Bob

 

[Shatin]

Dave,

You are absolutely right. The workbook was indeed quarantined. I am not
exactly sure why. I used Excel 97 until a few months ago and I had the
personal.xls while still using '97. Perhaps this is the reason??? As I
mentioned in another post, I have been using the personal.xls all the time
by opening it manually without problem and so am puzzled why Excel felt it
should be quarantined.

Anyway, the file opens automatically now. Many thanks for your help!

 

[Dave Peterson]

It's not just because it came from xl97. Excel thought that there was something
wrong with it.

I've seen excel be mistaken, but I'd make sure that I had a backup
available--just in case it becomes a recurring theme.

 

[Dave Peterson]

I have my personal.xla backed up in a couple of folders (at home and at
work)--in a zip file version, too. It's on a couple of those thumbdrives--just
stopped backing up to floppy.

Too much work (well, by others--copying and pasting from the NG's is my
responsibility <bg>) to lose!

 

[Ken Wright]

I've replicated the damn thing on every drive I've got, including a USB pendrive
as well. I go all cold and shivery if I can't access my damn file (On someone
else's machine for example), and the thought of losing it..............
<shivers>

 

[Jon Peltier]

Too much work (well, by others--copying and pasting from the NG's is

my responsibility <bg>) to lose!

LOL! You too, eh?

- Jon

 

[Jon Peltier]

I just started rebuilding mine. I took out a bunch of semideveloped
things that I no longer need, and Excel starts up much faster. I have
dozens of backups everywhere, and I never know which might have that
interesting thing I was working on.

- Jon

 

[Ken Wright]

LOL - rebuilding when you have access to your current bloated files, and
therefore a wealth of choice is one thing, but the thought of rebuilding from
scratch by having to search all that good stuff out again - Aaaagghh -
Nightmareeeeeee!!!!

 

[Dave Peterson]

If I had a Help|About, I'd have too many names to mention. And that alone
really slow down excel <vbg>.