ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - Auto opens files (https://www.excelbanter.com/excel-discussion-misc-queries/2148-excel-auto-opens-files.html)

173abn

Excel - Auto opens files
 
When starting excel, the program now opens or attempts to open every file in
the directory. What causes this & how can I correct it?

Frank Kabel

Hi
goto 'Tools - Options - General' and see what directory is defined for 'at
startup open all files in...'

--
Regards
Frank Kabel
Frankfurt, Germany

173abn wrote:
When starting excel, the program now opens or attempts to open every
file in the directory. What causes this & how can I correct it?




Gord Dibben

Can you get Excel to complete opening or does it just crash when it runs out
of resources?

If it will open................

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.

I would check the ToolsOptionsGeneral 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.

If Excel will not open and crashes, post back....you will need a Registry
modification.

Gord Dibben Excel MVP

On Fri, 17 Dec 2004 13:51:04 -0800, 173abn
wrote:

When starting excel, the program now opens or attempts to open every file in
the directory. What causes this & how can I correct it?




All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com