Stop opening multiple versions of Excel when click on xls files

S

stef

Excel 2002 SP3
Win XP HE

Hi,

If I click on an xls file in Windows Explorer, it properly starts Excel
and opens the file.

However, if I need another file opened, and click on another xls file
within Windows Explorer, instead of opening the file only, it starts up
a new instance of Excel.

So I can find myself with 3 or 4 (or more) instances of Excel running
simultaneously. It's not a huge problem but I believe not necessary and
would like to see if I can find a way of only opening the file in
question once Excel is already opened, etc.

Any ideas?

Thanks.
 
S

SpreadsheetBrian

Excel 2002 SP3
Win XP HE

Hi,

If I click on an xls file in Windows Explorer, it properly starts Excel
and opens the file.

However, if I need another file opened, and click on another xls file
within Windows Explorer, instead of opening the file only, it starts up
a new instance of Excel.

So I can find myself with 3 or 4 (or more) instances of Excel running
simultaneously. It's not a huge problem but I believe not necessary and
would like to see if I can find a way of only opening the file in
question once Excel is already opened, etc.

Any ideas?

Thanks.

You are not opening multiple copies of Excel, though you _do_ see each
opened workbook represented in your Start Bar. This is a convenience
that Excel introduces so that you can task-switch between spreadsheets
more easily.

By way of illustration, try to close one of the many "instances" of
Excel that you have open. If you close the application (rather than
just the workbook) you'll notice that ALL of your workbooks will close
down. This is because there is only one EXCEL running.

If I am not correct please repost.

Brian Herbert Withun
 
G

Gord Dibben

If it truly separate instances of Excel and just new windows in one instance

Try the usual fix(es) for this problem.

Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.


Gord Dibben MS Excel MVP
 
P

Peo Sjoblom

Tools>options>general, make sure ignore other applications is not checked

if that doesn't work you might want to re-register excel


close Excel


1) Windows>Start>Run, copy and paste

excel.exe /unregserver

then click OK

2) Windows>Start>Run copy and paste

excel.exe /regserver

click OK
 
S

stef

Guys,
Thanks for the comprehensive replies.
I do understand what you are saying and will check again on whether
really separate instances of Excel of just windows.
I do believe that multiple instances DO occur at times, as when I try to
right click Excel in taskbar to "close group", it just won't at
times--which would indicate to me (unless I am mistaken) that there are
indeed several instances of Excel running.
But again, I will check further and apply the solutions that all of you
guys kindly posted.
I'll post again here with result.
 
E

Earl Kiosterud

Stef,

Maybe it's just the "Windows in taskbar" option in Tools - Options - View. That puts each
workbook on the TaskBar and lets you Alt-Tab as if it each workbook is a separate
application. Could that be giving you the appearance of separate instances of Excel?
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
S

stef

Earl,
Yes, I checked and I DO have Windows in taskbar enabled.
I noticed that when that is enabled, you cannot close the "group" by
right clicking on Excel in the taskbar and "close group" which may have
given me the impression that there are multiple instances of Excel
running...?
 
E

Earl Kiosterud

Stef,

The taskbar buttons represent the document (workbook) windows, not the application (Excel)
window, it seems. With multiple workbooks open, and any with the focus, File - Exit or
Alt-F4 should cause Excel to close, closing all the the workbooks first. I think if it
happens that way on your system, it'll confirm that there's only one instance of Excel
running.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top