Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening excel creates an error message or opens Book 1
I want excel to open without Book 1. Following the thread below solves only
part the problem. This works for opening only excel, but does not appear to work when one double clicks on an existing excel file to open. I still get the Book 1 when this is done. The /automation modifier does not seem to help either. Our IT people put in a shortcut in the C:\Program Files\Microsoft Office\OFFICE11 directory with the /e /automation switch. The Control Panel/Folder Options/File Types was modified to open excel using this shortcut. Now, unless Excel is already open, a double click of an existing file gives a series of files not found errors. It seems to stumble over the spaces in the file structure such as between the word DOCUMENTS and the word AND when looking for a file in C:\Documents and Settings\Excel........ It says it cannot find the file Documents.xls. The /e used to work in older versions either with excel only or by double clicking on a exisitng file. Either way, no Book 1 ever appeared. I am after this same functionality. ksn "Dave Peterson" wrote: Modify the shortcut (or create an new shortcut) that points at excel.exe, but add " /e" (w/o the quotes) to the end of the target. For me (xl2003), my target would look like: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e Jwhite wrote: How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I open Excel? -- Dave Peterson -- ksn |
#2
|
|||
|
|||
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 Fri, 24 Jun 2005 15:25:02 -0700, ksn wrote: I want excel to open without Book 1. Following the thread below solves only part the problem. This works for opening only excel, but does not appear to work when one double clicks on an existing excel file to open. I still get the Book 1 when this is done. The /automation modifier does not seem to help either. Our IT people put in a shortcut in the C:\Program Files\Microsoft Office\OFFICE11 directory with the /e /automation switch. The Control Panel/Folder Options/File Types was modified to open excel using this shortcut. Now, unless Excel is already open, a double click of an existing file gives a series of files not found errors. It seems to stumble over the spaces in the file structure such as between the word DOCUMENTS and the word AND when looking for a file in C:\Documents and Settings\Excel........ It says it cannot find the file Documents.xls. The /e used to work in older versions either with excel only or by double clicking on a exisitng file. Either way, no Book 1 ever appeared. I am after this same functionality. ksn "Dave Peterson" wrote: Modify the shortcut (or create an new shortcut) that points at excel.exe, but add " /e" (w/o the quotes) to the end of the target. For me (xl2003), my target would look like: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e Jwhite wrote: How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I open Excel? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening an Excel template from a 3rd party app | Excel Discussion (Misc queries) | |||
existing excel file when clicked opens blank excel document | Excel Discussion (Misc queries) | |||
When opening an existing workbook, Excel opens but not the workbo. | Excel Discussion (Misc queries) | |||
Excel opens all files in My Documents on launch | New Users to Excel | |||
Mexport transfer from another program to excel opens at excel lau. | Excel Discussion (Misc queries) |