M
Mad Scientist Jr
I am using Excel 2003 (SP2) and wanted to view my Excel workbooks in
separate windows (I have 2 monitors and want different workbooks
displayed in each). Looking around online it seems the setting to allow
this is:
Tools > Options > General > Ignore other applications
I selected this, and it works. When I click on an Excel file in
Explorer, a new instance of Excel opens.
However, when Excel opens, there is no workbook. I had to click File >
Open and manually navigate to the file to edit it.
My first question was is this a known side effect or some anomaly? Is
there any way to fix this while still being able to open workbooks in
separate windows?
I tried to go in and edit the XLS file association (in Explorer, Tools
Windows cannot find
'C:\Documents and Settings\myuser\myfolder\sub path\myfile.xls'.
Make sure you typed the name correctly, and then try again.
I went back in to edit the XLS file association again and played
around, to no avail. Went back to re-edit the association and where
before there was an [Advanced] button, there was a [Restore] button,
which I clicked. Now it seems whenever I dbl click on an Excel file,
Excel (or Windows) is delimiting the file path by space, and trying to
open each word in the path as a separate Excel file.
For instance if I double click the file
C:\Documents and Settings\myuser\myfolder\sub path\myfile.xls
in Explorer, Excel opens and pops up these 5 or so error windows:
'C:\Documents.xls' could not be found.
'and.xls' could not be found.
'Settings\myuser\My.xls' could not be found.
'Documents\myfolder\sub.xls' could not be found.
'path\myfile.xls' could not be found.
It seems Excel is splitting the file path up by space, and thinks every
word in the file path is a separate Excel file name.
I'm not sure now if this is an Excel issue, a Windows issue, neither,
or both.
What can I do to fix this?
Much appreciated...
separate windows (I have 2 monitors and want different workbooks
displayed in each). Looking around online it seems the setting to allow
this is:
Tools > Options > General > Ignore other applications
I selected this, and it works. When I click on an Excel file in
Explorer, a new instance of Excel opens.
However, when Excel opens, there is no workbook. I had to click File >
Open and manually navigate to the file to edit it.
My first question was is this a known side effect or some anomaly? Is
there any way to fix this while still being able to open workbooks in
separate windows?
I tried to go in and edit the XLS file association (in Explorer, Tools
Folder Options > File Types), goto XLS, clicked [Advanced] > Open > Edit. I didn't change anything, just exited, but after that dbl-clicking on an XLS file gives the error:
Windows cannot find
'C:\Documents and Settings\myuser\myfolder\sub path\myfile.xls'.
Make sure you typed the name correctly, and then try again.
I went back in to edit the XLS file association again and played
around, to no avail. Went back to re-edit the association and where
before there was an [Advanced] button, there was a [Restore] button,
which I clicked. Now it seems whenever I dbl click on an Excel file,
Excel (or Windows) is delimiting the file path by space, and trying to
open each word in the path as a separate Excel file.
For instance if I double click the file
C:\Documents and Settings\myuser\myfolder\sub path\myfile.xls
in Explorer, Excel opens and pops up these 5 or so error windows:
'C:\Documents.xls' could not be found.
'and.xls' could not be found.
'Settings\myuser\My.xls' could not be found.
'Documents\myfolder\sub.xls' could not be found.
'path\myfile.xls' could not be found.
It seems Excel is splitting the file path up by space, and thinks every
word in the file path is a separate Excel file name.
I'm not sure now if this is an Excel issue, a Windows issue, neither,
or both.
What can I do to fix this?
Much appreciated...