ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple instances (https://www.excelbanter.com/excel-discussion-misc-queries/147646-multiple-instances.html)

Neil Levy

Multiple instances
 
I have a user at work who is having a problem when he opens certain excel
workbooks, that contains multiple worksheets. Several (3 or 4) instances of
this workbook open automatically, each with a diffirent sheet open.

Has anyone seen this and know what the fix is?


Chip Pearson

Multiple instances
 
It is likely not actually 3 or 4 separate instances of Excel. Excel is
probably configured to show each workbook in the taskbar. Go to the Tools
menu, choose Options, then View. There, uncheck the "Show windows in
taskbar" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Neil Levy" wrote in message
...
I have a user at work who is having a problem when he opens certain excel
workbooks, that contains multiple worksheets. Several (3 or 4) instances
of this workbook open automatically, each with a diffirent sheet open.

Has anyone seen this and know what the fix is?



Earl Kiosterud

Multiple instances
 
Neil,

It sounds as if multiple windows have been set up with Window - New window a few times. You
see stuff like "Budget:1" "Budget:2" in each window if this is the case. If "Windows in
taskbar" is checked (Tools - Options - View tab), then each window will appear on the
taskbar. If the workbook is saved with this multiple-window set up, then the next time it's
opened, they'll still be there. The fix is to close all but the last one (click the inner x
in the upper right corner). When all but one is closed, the colons will go away. Save the
file to keep that single-window setup.
--
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...
-----------------------------------------------------------------------
"Neil Levy" wrote in message
...
I have a user at work who is having a problem when he opens certain excel workbooks, that
contains multiple worksheets. Several (3 or 4) instances of this workbook open
automatically, each with a diffirent sheet open.

Has anyone seen this and know what the fix is?





All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com