Multiple instances of Excel opening when using Windows Explorer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cmanssur - 20 Jun 2007 12:04 GMT

Start at the bottom of the post and read up. Any help is appreciated.

"Ramesh, MS-MVP" wrote:

> No problem, cman. Hope someone at the Excel groups arrive at a solution!
>
> > Hi cman,

I can repro the problem by explicitly invoking excel.exe <filename.xls>
using a shortcut
or Run command. Perhaps your macro is using the same method, or does it use
shellexecute
direct .xls file?

> > Other options that I can think of:
> >
> > 1. See if repairing Excel helps, in case of incorrect file association/missing DDE strings
> > 2. Repost this question in Excel newsgroups,.
> >
> > > cmanssur,
> > >
> > > Just to be sure: Did you uncheck the Windows in Taskbar check box in Excel?

Show multiple program buttons on the Windows Taskbar - Excel - Microsoft
Office Online:

> > > > http://office.microsoft.com/en-us/excel/HP052702371033.aspx

When I open several files at once thru Windows Explorer, each file is opened
in a separate instance of Excel. I want all files in one instance of Excel;
i.e. all files should be visible from the Window pane of Excel. I have a
macro that opens each file separately (ActivateNext) and then closes each
file. This seems to be dependent on which work station around the office.
Some open one instance of Excel, some open several instances. How can I set
this up to only open one instance of Excel? I using Windows XP and Excel
2003.
--
cman

Reply to this Message

Gord Dibben - 20 Jun 2007 16:07 GMT

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

>Start at the bottom of the post and read up. Any help is appreciated.
>
[quoted text clipped - 30 lines]
> this up to only open one instance of Excel? I using Windows XP and Excel
> 2003.

Reply to this Message