Trouble with personal.xls loading at start up

5 views
Skip to first unread message

Ted Horsch

unread,
Jun 10, 2003, 7:16:35 PM6/10/03
to
I have a particular user on who's PC I can't get the
personal.xls file to load at start up. We run Office XP
on W2K Pro. I have loaded the personal.xls file to the
XLSTART folders (C:\Documents and settings\username\
Application Data\Microsoft\Excel or in C:\Program
Files\Microsoft Office\Office10). I've tried loading it
to both locations, then just one and then just the other,
but the result is the same--the file doesn't load. It's
not that it's loading and is hidden; I've checked for that
and the file simply isn't loading. Any suggestions short
of reinstalling Excel to solve this problem?

Thanks,

Ted

Dave Peterson

unread,
Jun 10, 2003, 11:04:57 PM6/10/03
to
I think I'd move all your experiments out of those folders.

Then record a new macro and have it saved in personal.xls. Save personal.xls
and close excel and reopen.

Did excel find that version?

If yes, then use windows|Find|Files or folders to find that new personal.xls and
replace it with your real one.

I could do this inside the VBE. Hit ctrl-G to see the immediate window and type
this and hit enter:
?application.StartupPath

It returned this for me (xl2002 and win98):
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

===========
If it still doesn't work, xl2002 can "quarantine" a file. Maybe the user got
prompted with a message that personal.xls was corrupt and then excel asked if it
should never open that file again.

You can reverse this under:
Help|About Microsoft Excel|and click on Disabled Items

===========
And you don't have any funny macros that close the file if everything isn't ok,
do you?

--

Dave Peterson
ec3...@msn.com

Ted Horsch

unread,
Jun 11, 2003, 8:07:13 PM6/11/03
to
Dave,
Thanks for your help on this. As it turns out the problem
was that the personal.xls file had been disabled. Doing
the Help|About Microsoft Excel|and click on Disabled Items
and enabling it did the trick. Glad I posted this
question--I never in a million years would have found this
without your help! Much obliged...
Ted Horsch

>.
>

Reply all
Reply to author
Forward
0 new messages