can i change a setting in excel so that when i click on a new excel document
icon from my desktop that it will open in a new window and not open in the
same window that is already open??

Depending upon version, you can go to ToolsOptionsView and checkmark
"Windows in Taskbar"

I believe this feature was introduced in Excel 2000.


Gord Dibben Excel MVP

On Thu, 14 Apr 2005 09:59:03 -0700, "lost in excel" <lost in
wrote:

can i change a setting in excel so that when i click on a new excel document
icon from my desktop that it will open in a new window and not open in the
same window that is already open??

can i change a setting in excel so that when i click on a new excel
document icon from my desktop that it will open in a new window and
not open in the same window that is already open??

With Excel 97, I'm unaware of a "setting," but these two ways might help
get separate windows for different excel documents.

#1. From the Windows "Start" menu, use the cascaded menu to open Excel.
Once Excel is running, use "File Open" to open an Excel file. Repeat the
steps for the second file.

#2. Point to an Excel file on the desktop or in a folder. With the right
mouse button, click "Send To Excel". Repeat the steps for the second
file.

For #2, you might not see "Excel" in the "Send To" menu at first. To add it
there, put a shortcut to the Excel program into the folder
C:\Windows\SendTo\

By the way, if you have two files of the same name in different folders,
this allows you to have both open at the same time.