Excel 2000 Auto Opens 24 files on startup

[Guest]

Hello. I am having a problem with excel. Whenever I start excel, or double
click an excel spreadsheet to open, it automatically starts 24 excel files.
I have tried looking in the xlstart folder for any templates or anything of
the sort, but did not find anything.

Any help or suggestions in stopping this from happening would be appreciated.

 

[Gord Dibben]

Tools>Options>General.

Delete any path in "at startup open all file in".

Older versions...."Alternate startup file location".


Gord Dibben MS Excel MVP

 

[Roger Govier]

Hi Alex

Take a look at Tools>Options>General>At startup, open all files in
Remove any folder name in that location.
This is the wording in XL2003.
I believe in earlier versions, it is names Alternate startup location.

 

[Guest]

Hi Gord,

Excel 2000 does not have the "at startup open all files in" Option in the
general tab.

Also, the alternate startup file location path is blank...

Cheers

CSUFAlex

 

[Gord Dibben]

OK

Are you sure you are looking in the correct XLSTART folder.

Office often creates more than one when installing.

Do a search for xlstart and see what comes up.

In Windows XP and Office 2003 my correct XLSTART folder is at

"C:\Documents and Settings\Gord\Application Data\Microsoft\Excel"

There is also one at

C:\Program Files\Microsoft Office\OFFICE11\XLSTART but it doesn't do anything I
can see.


Gord

 

[Dave Peterson]

Try determining where those 24 files are coming from:

After one opens, put this in any cell:
=cell("Filename",a1)

You'll see where they're coming from.

Then you can verify that that folder doesn't exist under tools|Options|General
tab.

 

[Guest]

Hi, networked environment was backing up the profile to a server, which is
where the Application Data/Microsoft/Excel/XLStart items were.

Thanks for the help...

CSUFAlex

 

[Guest]

Dave,

That did the trick, I found the location...thanks a bunch!!

CSUFAlex