Excel 2003 Opens Up Every File in My Documents

G

Glenn Reschke

Each time Excel is opened, multiple files open in Excel. Some fo thes
files
are .xls, .lwp (Lotus WordPro), .dbf, you name it but all of them ar
in the My Documents directory on my root hard drive (I have two C: i
the base if you will and D: is for storage mostly.

There are no
links are macros associated with any of these files. I just want t
open
Excel and see a blank workbook. I recently was upgraded to Office 200
but
also have a brand new box. So all files were created in Office 200
with
WIN2K as OS. Now I have 2003 with WINXP as OS. Any suggestions? Bea
in mind I can't even stop the files they just keep opening up b
themselves and would until RAM was exhausted. I can't get a clea
sheet to go into Tool/Options or go to the Genral Tab under Options th
At startup, open those
all files was populated instead of the default file location box. I ca
only close them all down via the TaskManager.

I've also deleted every file in the XLStart directories for all of the
associated with Office.

I saw one post that said, "I guess there are some files in XLStar
directory. Excel opens every file in XLStart directory each time i
starts.
Search your computer for XLStart and look in to the found directories.

Also In Options menu, General Tab, Open every file on startup i
directory (could be similar to this. I have non-english version
TextBox should be empty unless if you do not use." That would be grea
but again let me be clear I can't access any menu option at all
Period. Help!!!

Regards,
G
 
J

JE McGimpsey

Sounds like you entered "My Documents" as your "Alternate startup file
location" folder in Tools/Options/General...
 
G

Gord Dibben

Glenn

Since you crash due to the number of files trying to open, a Registry change
is needed to get rid of the pathname in Alternate Startup File Location.

If you want to edit the Registry you will find the key value here.....

Start>Run "regedit"(no quotes)OK

HKEY_Current_User/Software/Microsoft/Office/X.0(X is your version
number)/Excel/Microsoft Excel.

97 = 8.0
00 = 9.0
02 = 10.0
03 = 11.0

On right-hand pane you will see AltStartUp. Right-click and Modify by
deleting any path.

Gord Dibben Excel MVP
 
P

Peo Sjoblom

Or temporarily move the folder somewhere else, start excel, remove the
alternative path and move the folder back again
 
G

Gord Dibben

Assuming OP knows what is entered as a path in that dialog box.

Some don't.


Gord
 
Top