 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / December 2006Opening Excel
I've created an Excel template and put it into the recommended location and it works. However, when I open an existing Excel workbook from explorer, instead of just opening the workbook that I want opened, it also opens a blank workbook. I have to go close the blank workbook separately, which is a real pain. How can I keep this "extra" blank workbook from opening every time I open an existing workbook? I am using Excel 2003 (11.8033.8036) SP2. Barry 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\OFFICE9\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 MS Excel MVP >I've created an Excel template and put it into the recommended location and >it works. However, when I open an existing Excel workbook from explorer, >instead of just opening the workbook that I want opened, it also opens a >blank workbook. I have to go close the blank workbook separately, which is a >real pain. How can I keep this "extra" blank workbook from opening every >time I open an existing workbook? I am using Excel 2003 (11.8033.8036) SP2. Gord Dibben MS Excel MVP My settings were already set as you noted below. However, I went in and tried to remove the /e and now it keeps putting in a "%1" at the end and I can't get rid of it. Also, when I open an existing document, I now get an error msg. "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e %1 > Barry > [quoted text clipped - 24 lines] > > Gord Dibben MS Excel MVP Barry What is the error message you get? Try this method to re-register Excel after removing the /e from the path. Close Excel first and On the Windows Taskbar 1) Start>Run "excel.exe /unregserver"(no quotes)>OK. 2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK. Gord Dibben MS Excel MVP >My settings were already set as you noted below. However, I went in and >tried to remove the /e and now it keeps putting in a "%1" at the end and I [quoted text clipped - 31 lines] >> >> Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP I asked our help desk to correct the problem yesterday and they did a "Repair" install of MS Office that removed the problem. However, I still have my original issue, that of an empty workbook opening when I open an existing workbook. Some additional information... I've created a template with headers and footers that I want to default for everything I create. I've been doing this for multiple versions and only this last version have I had a problem like this. I've stored the .xlt in the following directory: I created a workbook called BOOK.xlt and put it into the directory C:\Program Files\Microsoft Office\Office11\XLStart Again, my problem is when I double click from explorer an existing workbook that I just want to open and edit, it also opens a new workbook, becuase of this template I've created. My template settings are all ok, but I'm tired of having to close this empty workbook that I don't really want. If I first open Excel, then do a file/open, I don't have the problem, but who wants to do that all of the time. Again, I've done this for many many previous versions of Excel and never had a problem. I also do this for WORD and have never had a problem, nor am I having a problem with WORD now, just Excel. Does that shed any more light on my problem ? thanks in advance. > Barry > [quoted text clipped - 50 lines] > > Gord Dibben MS Excel MVP Barry If you truly saved a BOOK.XLT as a Template in your XLSTART folder, this is not the blank workbook that opens. Templates do not open unless called for with File>New. If you just saved as a regular workbook. it will open when Excel starts. Is the name of the blank workbook Book1.xls? If so, that is Excel's default blank WB. Try this method. In Tools>Options>General, uncheck "Ignore other applications" if already checked. I have always had success with setting the /e appended to the command line as previously noted. Gord >I asked our help desk to correct the problem yesterday and they did a >"Repair" install of MS Office that removed the problem. However, I still [quoted text clipped - 70 lines] >> >> Gord Dibben MS Excel MVP Well... I really appreciate all of your effort, but I don't think you've zeroed in on my problem yet. I do truely (just double checked) have a workbook named "Book.xlt" in my XLSTART folder that is opening. I proved this, because when I remove it, I don't have the problem, but I also don't have my defaults I'm attempting to get. Lastly, the check box you say to turn off (uncheck) under tools is already off. :-( any other suggestions? > Barry > [quoted text clipped - 92 lines] > >> > >> Gord Dibben MS Excel MVP Did you actually save as>file type>excel template(*.xlt) or did you just save as and added the xlt yourself. True *.xlt files will not open when Excel starts. Re-create a workbook with some formatting etc. and File>Save As>File Type>Template(*.xlt) Name it BOOK......do not add the .xlt Click Save. Move that BOOK.XLT into the XLSTART folder. Does it open when Excel is started? Another guess................ Go to Tools>Options>General and delete any path in "At startup, open all files in" You may have a book.xls in that folder. Gord >Well... I really appreciate all of your effort, but I don't think you've >zeroed in on my problem yet. I do truely (just double checked) have a [quoted text clipped - 99 lines] >> >> >> >> Gord Dibben MS Excel MVP YOU GOT IT! Thank you very much. I must have created the workbook and just renamed it with the extension of .xlt instead of saving it as a template. This has been nagging me for 9 months now. Problem solved. Again, thank you very much. Resolved. > Did you actually save as>file type>excel template(*.xlt) or did you just save as > and added the xlt yourself. [quoted text clipped - 122 lines] > >> >> > >> >> Gord Dibben MS Excel MVP Whew! Glad we got that done. Common mistake.........just manually adding the .xlt does not create a Template. Gord >YOU GOT IT! Thank you very much. I must have created the workbook and just >renamed it with the extension of .xlt instead of saving it as a template. [quoted text clipped - 127 lines] >> >> >> >> >> >> Gord Dibben MS Excel MVP is there a way to get rid of the %1 without having the office install handy? > Barry > [quoted text clipped - 50 lines] > > Gord Dibben MS Excel MVP Whe I use the excel.exe /regserver command the Windows installer goes through its "re-installing" without asking for a CD Does this not work for you? Gord >is there a way to get rid of the %1 without having the office install >handy? [quoted text clipped - 53 lines] >> >> Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.