editing setup defaults

A

amy

In Excel 2002, when I open an existing worksheet, it automatically opens a
blank excel template. How do I turn this off?
 
G

Gord Dibben

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new blank book from
opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BOOK and PERSONAL 1
Excel Protection 2
Opening Excel 11
How do I change File > Open default directory from My Documents 3
Excel is opening templates as templates instead of as worksheets 1
Excel - automatically saves as a 'TEMPLATE' 1
change excel sheet defaults 2
New Blank Workbook 2

Top