When we double click on an Excel Spreadsheet file to open it, it will start Excel, but will start it with a blank spreadsheet, not the selected file. Then we have to go and select File/Open...etc... Has anyone ever experienced this behavior? Thanks...it is a small annoyance, but wanted to see if we are doing something wrong...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel XP - Blank worksheet opening after selecting file
- Thread starter mdcr
- Start date
2 things to check for that I can think of right off hand.
One, do you have any workbook setup to automatically open when Excel open, such as Personal.xls that may be setup automatically when you record a macro into your personal workbook? Please note, the Personal.xls workbook is normally hidden when it's openned, so that shouldn't impact it. The only time when I have noticed in particular excel not open the workbook that was clicked on is when it opens a form from another workbook that is automatically opened, and the code steps there. I have a such situation like that, but that was done by design. If that is the cause, just close out the form, then you should be able to open another workbook either from the OpenFile dialog box or from Windows Explorer.
There's 3 possible places where workbooks can be stored to be openned automatically.
<RootDrive>:\Program Files\Microsoft\Office\XLStart
<RootDrive>:\<UserProfilePath\ApplicationData\Microsoft\Office\Excel\XLSTART
The alternate startup location that is listed in the Options dialog on the General tab, if anythingis listed in there.
For more information, click on the link below:
The other possible issue, but I wouldn't think is near as likely, do you have a default workspace configuration saved. Me, I have not worked with the workspace so much in Excel, so I wouldn't be of much help there.
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
One, do you have any workbook setup to automatically open when Excel open, such as Personal.xls that may be setup automatically when you record a macro into your personal workbook? Please note, the Personal.xls workbook is normally hidden when it's openned, so that shouldn't impact it. The only time when I have noticed in particular excel not open the workbook that was clicked on is when it opens a form from another workbook that is automatically opened, and the code steps there. I have a such situation like that, but that was done by design. If that is the cause, just close out the form, then you should be able to open another workbook either from the OpenFile dialog box or from Windows Explorer.
There's 3 possible places where workbooks can be stored to be openned automatically.
<RootDrive>:\Program Files\Microsoft\Office\XLStart
<RootDrive>:\<UserProfilePath\ApplicationData\Microsoft\Office\Excel\XLSTART
The alternate startup location that is listed in the Options dialog on the General tab, if anythingis listed in there.
For more information, click on the link below:
The other possible issue, but I wouldn't think is near as likely, do you have a default workspace configuration saved. Me, I have not worked with the workspace so much in Excel, so I wouldn't be of much help there.
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
- Status
Similar threads
- Locked
- Question