excel 2003: one base window ???

  • Thread starter Thread starter Lynn McGuire
  • Start date Start date
L

Lynn McGuire

What is wrong with Excel 2003 ???? I just moved from Excel 2000.

I cannot view two spreadsheets simultaneoulsy with other application
windows without having the base Excel window maximized ! This is
crazy ! I have this stupid Excel base window obscuring all my other
windows.

I have looked all over the options to stop this stupid, stupid, stupid
behavior. I cannot find anything to change this.

Lynn
 
I do it all the time.

I open multiple workbooks in the same instance of excel.
Then Window|Arrange|tiled (or what I want).

The application doesn't need to be maximized.

==
But I really don't know what excel's base window is--so maybe I'm not answering
the real question.
==

Any chance you have multiple instances of excel running?
When you click on Window, do you see all the open workbooks (that you think) or
just one?

If you only see one (and you expected more), then I'm betting you opened the
secondary (and others) by doubleclicking them in windows explorer--and they got
opened in separate instances.

One of these sometimes fixes that problem:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
Any chance you have multiple instances of excel running?

I wish I could run mutiple instances of Excel. That would be the answer
to my issues.

I just locked up Excel a little while ago because I was sending a spreadsheet
as a email, I double clicked on the spreadsheet in the email message to
re-open it and bang, excel 2003 was toast ! I have a dual Opteron 250
with 2 GB of ram running Windows XP Pro. I should be able to multi-task
spreadsheets at will !

Lynn
 
If you want to run multiple instances of excel, I think the best thing to do is
to start the first anyway you want.

But then start the second (and subsequent instances) from a shortcut or from:
windows start button|Run
Excel
ok

Then File|Open your second workbook.
 
If you want to run multiple instances of excel, I think the best thing to do is
to start the first anyway you want.

But then start the second (and subsequent instances) from a shortcut or from:
windows start button|Run
Excel
ok
Click to expand...

Yup, that works. It sucks though. Totally defeats the usefullness of double
clicking on excel files in emails / folders / etc...

Thanks,
Lynn
 
You could try:

Tools|options|General tab|Ignore other applications (check it)

Then double click on the workbook in windows explorer.

And be aware that turning this setting off sometimes gives errors with workbooks
that contain spaces in their path/name:

C:\my documents\excel\my book.xls

The error will look kind of like:
cannot find c:\my ..
then
cannot find documents\excel\my
then
cannot find book.xls

==
It may be easier/safer/more reliable to start the second instance and then
File|open the workbook.
 
Back
Top