Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Shortcut file fails to open
I have used a quicklauch icon for years to start Excel with a default file
automatically opened. Suddenly this has quit working. Excel opens, I see a virus scan being requested in the status bar, but everthing ends with Excel open but no with no loaded worksheet. I haven't changed anything lately. I have tried deleting and recreating the shortcut. I have tried changing the file to a different workbook. Nothing works. The workbooks are ok in that they load just fine using file/open once Excel loads. Has there been some automatic update lately that might have caused this? Any ideas at all? Thanks JimH |
#2
|
|||
|
|||
Hi, JimH;
I just tried this: dragged a shortcut (to one of my Excel workbooks) onto Quicklaunch. Clicked it. The Workbook opened. Is this what doesn't work for you? Another way: Tools Options General At startup, open all files in:... Put the path to your workbook in there. This "should" open that workbook whenever Excel started, regardless of whatever other workbook you were opening, and regardless of what method you used to open Excel. Is there a path in that box? Regards, Ianroy. "JimH" wrote: I have used a quicklauch icon for years to start Excel with a default file automatically opened. Suddenly this has quit working. Excel opens, I see a virus scan being requested in the status bar, but everthing ends with Excel open but no with no loaded worksheet. I haven't changed anything lately. I have tried deleting and recreating the shortcut. I have tried changing the file to a different workbook. Nothing works. The workbooks are ok in that they load just fine using file/open once Excel loads. Has there been some automatic update lately that might have caused this? Any ideas at all? Thanks JimH |
#3
|
|||
|
|||
Yes, the icon created by dragging a workbook file onto quicklaunch is
precisely what used to work but now doesn't. I deleted the icon, recreated it, created one by dragging a different workbook to the ql bar - all the obvious things one might be expected to try. None worked. The shortcut properties clearly point to the file. As I said before, it appears that excel tries to open the file in that Norton steps in to scan (excel status bar displays "requesting virus scan" for a few seconds). There are no error messages, excel remains open, there just isnt any open workbook. As for the Tools/Options/General approach, I have dozens of files in a workbook directory. I certainly dont want Excel opening them all everytime I start Excel. I'll have to pass on that approach. Anyway, I shouldn't have to pull a work-around for something that has worked just fine for years. Any other thoughts? JimH "IanRoy" wrote: Hi, JimH; I just tried this: dragged a shortcut (to one of my Excel workbooks) onto Quicklaunch. Clicked it. The Workbook opened. Is this what doesn't work for you? Another way: Tools Options General At startup, open all files in:... Put the path to your workbook in there. This "should" open that workbook whenever Excel started, regardless of whatever other workbook you were opening, and regardless of what method you used to open Excel. Is there a path in that box? Regards, Ianroy. "JimH" wrote: I have used a quicklauch icon for years to start Excel with a default file automatically opened. Suddenly this has quit working. Excel opens, I see a virus scan being requested in the status bar, but everthing ends with Excel open but no with no loaded worksheet. I haven't changed anything lately. I have tried deleting and recreating the shortcut. I have tried changing the file to a different workbook. Nothing works. The workbooks are ok in that they load just fine using file/open once Excel loads. Has there been some automatic update lately that might have caused this? Any ideas at all? Thanks JimH |
#4
|
|||
|
|||
Hi. JimH;
I wasn't advocating the Tools/Options/General approach, I just thought that's what you might have done ("default file"), and there was a typo in that path. I found an entry in Excel online help entitled "Customize how Excel starts." There is this item: "Use startup switches when you start Excel." The startup switch that may help is /regserver. If using WinXP, I'd set a restore point, and then run Excel with that switch once, and see if that fixed it. PS: Norton runs a virus scan whenever I open Excel, it doesn't seem to be an indication that Excel is trying to open an existing workbook. Regards, IanRoy. "JimH" wrote: Yes, the icon created by dragging a workbook file onto quicklaunch is precisely what used to work but now doesn't. I deleted the icon, recreated it, created one by dragging a different workbook to the ql bar - all the obvious things one might be expected to try. None worked. The shortcut properties clearly point to the file. As I said before, it appears that excel tries to open the file in that Norton steps in to scan (excel status bar displays "requesting virus scan" for a few seconds). There are no error messages, excel remains open, there just isnt any open workbook. As for the Tools/Options/General approach, I have dozens of files in a workbook directory. I certainly dont want Excel opening them all everytime I start Excel. I'll have to pass on that approach. Anyway, I shouldn't have to pull a work-around for something that has worked just fine for years. Any other thoughts? JimH "IanRoy" wrote: Hi, JimH; I just tried this: dragged a shortcut (to one of my Excel workbooks) onto Quicklaunch. Clicked it. The Workbook opened. Is this what doesn't work for you? Another way: Tools Options General At startup, open all files in:... Put the path to your workbook in there. This "should" open that workbook whenever Excel started, regardless of whatever other workbook you were opening, and regardless of what method you used to open Excel. Is there a path in that box? Regards, Ianroy. "JimH" wrote: I have used a quicklauch icon for years to start Excel with a default file automatically opened. Suddenly this has quit working. Excel opens, I see a virus scan being requested in the status bar, but everthing ends with Excel open but no with no loaded worksheet. I haven't changed anything lately. I have tried deleting and recreating the shortcut. I have tried changing the file to a different workbook. Nothing works. The workbooks are ok in that they load just fine using file/open once Excel loads. Has there been some automatic update lately that might have caused this? Any ideas at all? Thanks JimH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My document won't open, tells me file format is not valid | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) |