Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Melissa
 
Posts: n/a
Default How do I stop a new file from opening automatically?

How do I stop a new Excel File from opening when I open an existing file?
This is a small but frustrating problem.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Melissa

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and
On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.

One more thing to try if any of the above brings no joy.........

Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

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

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp/e if
you want Book1 to open.

You must have the double quotes.

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

Application should read "Excel"(no quotes)


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 10:23:05 -0800, "Melissa"
wrote:

How do I stop a new Excel File from opening when I open an existing file?
This is a small but frustrating problem.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a file with a Macro Adam1 Chicago Excel Discussion (Misc queries) 2 February 28th 05 10:13 PM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM
Opening CSV file in Excel 97 Ron P Excel Discussion (Misc queries) 4 January 14th 05 10:41 PM
restrict opening Excel file residing on a shared drive to one user k-ham Excel Discussion (Misc queries) 1 January 7th 05 01:57 AM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 03:39 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"