Hi there, I got this question posed to me in an email. Can anyone help me out with it? Thanks, Dawn
"When I double-click on an Excel file in Windows Explorer, it normally opens -- Boom, no problem. Yesterday, however, I made a change in the Options - Default File Location setting, and the next time I tried to open a file from Explorer, it started to TRY to open ALL of the other files in this default location! (I got an error message something like "not a recognizable format", since they weren't Excel files; once I canceled through all the error messages, the file I was originally trying to open FINALLY opened, just fine). Tried to reboot and reopen the file via Explorer -- same thing. Since all these files in the new default location were old unused files, I deleted them (that directory is now EMPTY, except for several folders in it), but Excel still wants to open the files that now aren't there (BTW, now the error is "___________ file could not be found"
. > > Next, I changed the default file location back to what it originally was, but Excel still tried to open the files in the "new" location (that are no longer there)... > > Next, I went back and REINSTALLED EXCEL -- no matter what I set the default location to, Excel's still trying to open the files (in the "new" location, that are no longer there)... > > Note, this all ONLY happens when Excel is closed, and I try to open an Excel file from Explorer... once Excel is open (which I can do via Start or anything else that runs Excel.exe only, but doesn't open a file initially), opening subsequent files via double-clicking in Explorer works fine! Also, opening files from within Excel with File-Open works fine. > > SO, it seems to me that there's some parameter SOMEWHERE that wants to "auto-open" all these other mystery files (that are no longer there) whenever I try to open an Excel file via Explorer -- that's the only scenario that seems to not work right! Unfortunately, it's the one I use 99.99% of the time!"
"When I double-click on an Excel file in Windows Explorer, it normally opens -- Boom, no problem. Yesterday, however, I made a change in the Options - Default File Location setting, and the next time I tried to open a file from Explorer, it started to TRY to open ALL of the other files in this default location! (I got an error message something like "not a recognizable format", since they weren't Excel files; once I canceled through all the error messages, the file I was originally trying to open FINALLY opened, just fine). Tried to reboot and reopen the file via Explorer -- same thing. Since all these files in the new default location were old unused files, I deleted them (that directory is now EMPTY, except for several folders in it), but Excel still wants to open the files that now aren't there (BTW, now the error is "___________ file could not be found"
. > > Next, I changed the default file location back to what it originally was, but Excel still tried to open the files in the "new" location (that are no longer there)... > > Next, I went back and REINSTALLED EXCEL -- no matter what I set the default location to, Excel's still trying to open the files (in the "new" location, that are no longer there)... > > Note, this all ONLY happens when Excel is closed, and I try to open an Excel file from Explorer... once Excel is open (which I can do via Start or anything else that runs Excel.exe only, but doesn't open a file initially), opening subsequent files via double-clicking in Explorer works fine! Also, opening files from within Excel with File-Open works fine. > > SO, it seems to me that there's some parameter SOMEWHERE that wants to "auto-open" all these other mystery files (that are no longer there) whenever I try to open an Excel file via Explorer -- that's the only scenario that seems to not work right! Unfortunately, it's the one I use 99.99% of the time!"