MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Stop personal.xls opening


Posted by Roger on January 21, 2002 3:52 PM

How can I stop excel 2000 opening personal.xls when it opens. I want to run more than one instance of excel but when the second opens it displays a dialog saying personal.xls is locked for editing. This spoil my standalone spreadsheet application.


Posted by Jacob on January 21, 2002 3:59 PM

Hi

Just delete the personal.xls in the excel startup folder and there wont be anything to open.

Jacob

Posted by Bariloche on January 21, 2002 9:01 PM

Alternatively...

Roger,

Just close the Personal.xls workbook (programmatically) before you create the second instance.

have fun

Posted by AB on January 23, 2002 5:49 AM

Click the Windows "Start" button and select "Run". Then use the following command line syntax for Excel to startup with a clean boot. This will bypass all files in the Xlstart and Alternate Startup Files folders.

C:\excel /s

Obvioiusly, you'll have to modify the above for proper path to your excel.exe file.