When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
Brian
To prevent Book1 from opening you can append /e to your shortcut for opening
Excel.
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File 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">Open>Edit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e.
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 Fri, 9 Dec 2005 15:38:02 -0800, "Brian" <Brian@discussions.microsoft.com>
wrote:
>When I click on an excel file, 2 excel documents open up. One document is
>called Book1 and the other document is the actual document that I want to
>open. How do I stop this from happening?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks