All you describe below is nothing more than restoring or 'de-maximizing' a
window. I have Excel 2003 running right now. By default each file is
maximized. If, however, you click on the WORKSHEET'S restore button, it
will shrink in size a little and then allow you to resize that sheet just as
you describe below. Open another file and resize to your wishes. Common,
everyday Windows behavior
If this is all you need, then you did a very poor job of describing your
issue, and bear the responsibility for wasting others' time, instead of, as
you claimed, that others trying to help were wasting your time. You were
horribly rude and boorish
"Jason Dove" wrote in message
...
I apologize, but you are mistaken, and the question was not answered.
Prior to Excel 2003, Excel would open in separate program window whenever
an
additional file was opened. For an example of what would appear on your
computer screen, please open Microsoft Word. Open a file and change the
shape of the window into the right corner. While still in that window, go
to
File - Open and choose a second file. A new window should open and you
should be able to move that file down to the left corner. Now you have
two
separate windows of Word open with which you can work. This same
functionality was available in Excel; however, it seems to no longer be
the
default.
We gain absolutely no functionality with the "Windows in Taskbar". I'm
not
sure how it becomes added benefit to have to tab between windows when
separate windows can be opened simultaneously on the computer screen. My
company uses Excel spreadsheets extensively and have no need to "compare"
spreedsheets, but rather have several open while working. It requires
time
and, therefore, money, to have to tab through several spreadsheets to get
the
one we need up when they could be open in separate windows. That is how
we
preformed work prior to Windows 2003 and since our upgrade we have been
trying to reestablish that setting to make work easier for all our users.
The Same Program Window may be great for you, but it's not a functionality
that has benefitted our company.
"Duke Carey" wrote:
On the contrary, Peo DID answer your question. The option you seek isn't
and
wasn't a 'feature' of Excel, or certainly not any recent version of
Excel. I
haven't used Excel 97 for a *long* time, so can't swear about that
version,
but would bet that you are in error in your assertion.
Certainly you have never been able to use Excel's FileOpen menu to
create
what you have called an 'exterior' window, or what sounds like a separate
instance of Excel.
Moreover, what possible functional value is there to what you seek that
cannot be gained from the "Windows in Taskbar" view option?
"Jason Dove" wrote:
Thanks, but that doesn't answer the question.
"Peo Sjoblom" wrote:
You must be very thick having the nerve asking the same question in a
peer to
peer NG after your rude behaviour earlier, this is not MS helpdesk.
Excel does not have this functionality regardless of what you think,
2002
didn't have it, 2000 didn't have it etc, Word has it, only way is to
select
ignore other applications and open 2 independent copies of Excel
Regards,
Peo Sjoblom
"Jason Dove" wrote:
Prior to Windows 2003, when opening different excel files, the
files would
open in their own Excel Programs windows. This feature still
exists with
Word 2003, but I have not seen this feature in Excel.
Methods suggested to mimic this setting is to go to Tools -
Options
"Windows in Taskbar" or "Ignore Other Applications" or Open Two
Separate
Programs from the Start Menu. Also the Window - "Compare" method
has been
suggested; however, I don't want to compare two different
worksheets, I want
to have two separate worksheet programs open.
Is there a setting available so that each file of Excel that is
opened can
be opened in its own Program Window? For Example, Tools -
Options - View
"Open Files in Own Program Window"?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader
and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc