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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jg - 15 Jun 2007 04:17 GMT

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.

Reply to this Message

Roger Govier - 15 Jun 2007 09:56 GMT

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.

Signature

Regards

Roger Govier

>I recently (finally) upgraded from Excel 2002 to Excel 2003 (on Windows
>XP Pro, sp2).
[quoted text clipped - 20 lines]
> I have not installed or deleted any software, nor have I changed any
> settings in Excel.

Reply to this Message