Personal.xls doesn't open when starting with existing workbook

[jg]

I recently (finally) upgraded from Excel 2002 to Excel 2003 (on Windows XP
Pro, sp2).

Today, Excel crashed. I rebooted, then opened an existing Excel workbook,
and discovered that my macros were not available, because Personal.xls
didn't open.

So I exited, and opened Excel directly (without opening an existing
workbook). This time, the macros were there and Personal.xls was open.

AFAIK, this is not how Excel has behaved in the past - Personal.xls has
always opened no matter how I started Excel.


Here's what I've tried so far, none of which has helped:
- Rebooted
- Renamed Excel11.xlb to Excel11.old
- Moved Personal.xls to a new folder, and pointed Excel to that new folder
- Re-registered Excel
- "Detect and repair"

I have not installed or deleted any software, nor have I changed any
settings in Excel.

 

[Roger Govier]

Hi

press Alt+F11 to bring up the VB Editor
In the immediate pane type (if Immediate pane is not visible, invoke
with Ctrl+G)
?Application.StartupPath
and it should return something like
C:\Documents and Settings\Roger Govier\Application
Data\Microsoft\Excel\XLSTART

Place your Personal.xls in the folder it shows.