Opens all spreadsheets

[JOHN-C]

This is an installation of Excel 2002 on XP Pro. When
program is executed, it immediately opens every
spreadsheet saved in My Documents. Have scanned for
viruses and spyware, but the problem persists. HELP
Please.

 

[kkknie]

One way for this to happen is if you have specified My Documents as an
alternate startup location.

Check Tools | Options and the General Tab.
There is a textbox saying "At startup, open all files in:"

If this says My Documents, there's your problem.

K

 

[Gord Dibben]

John

Excel will try to open any files it finds in either the XLSTART folder or
"Alternate startup file location" or "at startup, open files in". This could
be the source of your problem.

First thing I would try is to start Excel in Safe Mode so you bypass any
XLSTART folder or "Alternate startup file location" if you have one entered.

Enter this at Start>Run(your path may differ) to start in Safe Mode

"C:\Program Files\Microsoft Office\Office\excel.exe" /s

Your path may differ.

Then I would check the Tools>Options>General and delete any path in "Alternate
startup file location".

I would move any files from the Office\XLSTART folder that aren't
Personal.xls, Book.xlt or Sheet.xlt.

Gord Dibben Excel MVP