Excel 2007 - Can't switch to already open spreadsheets

  • Thread starter Thread starter Jim Lally
  • Start date Start date
J

Jim Lally

So here's my issue:

Excel 2007 user opens more than one spreadsheet, however, when (in Excel)
you attempt to use the Switch Windows toolbar button, it only lists ONE
sheet open. Opening subsequent spreadsheets results in an individual
instance of Excel for each worksheet (and for each one, if you try and
switch windows, you only see the one sheet open in that particular
workbook).

How can I get it to behave properly, so that I have one instance of Excel
open.....and multiple spreadsheets that I can switch to within the single
instance of the application.

Can't understand what's going on. I'm sure someone here will know what I
can do.

(e-mail address removed)
 
It sounds as if you're opening workbooks by double-clicking in Explorer and
each workbook causes a new Excel instance. If so, if you open Excel and
then File, Open the workbooks do you get the behavior you expect?

--
Jim
| So here's my issue:
|
| Excel 2007 user opens more than one spreadsheet, however, when (in Excel)
| you attempt to use the Switch Windows toolbar button, it only lists ONE
| sheet open. Opening subsequent spreadsheets results in an individual
| instance of Excel for each worksheet (and for each one, if you try and
| switch windows, you only see the one sheet open in that particular
| workbook).
|
| How can I get it to behave properly, so that I have one instance of Excel
| open.....and multiple spreadsheets that I can switch to within the single
| instance of the application.
|
| Can't understand what's going on. I'm sure someone here will know what I
| can do.
|
| (e-mail address removed)
|
|
|
|
 
Hi Jim

Round Office button>Excel Options>Advanced>Display>untick Show all
windows in Taskbar
 
Back
Top