ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Multiple Excel Sessions (https://www.excelbanter.com/excel-discussion-misc-queries/132773-opening-multiple-excel-sessions.html)

Lynn

Opening Multiple Excel Sessions
 
When I open multiple sessions of Excel, you cannot see all of them under the
same Window to move from one session to the other. How can this be resolved?

In addition, the formatting for color will change on 1 sheet only when I
move a session to another session as a second tab.

How can this be corrected?

Office XP has already been uninstalled and re-installed without success in
resolving this issue.



Bob Umlas, Excel MVP

Opening Multiple Excel Sessions
 
I don't believe it's "resolvable" -- it's by design. Separate sessions of
Excel don't "talk" to each other. You'd need alt/tab to switch from one to
the other.

"Lynn" wrote:

When I open multiple sessions of Excel, you cannot see all of them under the
same Window to move from one session to the other. How can this be resolved?

In addition, the formatting for color will change on 1 sheet only when I
move a session to another session as a second tab.

How can this be corrected?

Office XP has already been uninstalled and re-installed without success in
resolving this issue.



Lynn

Opening Multiple Excel Sessions
 
Prior to having my hard drive replaced a month ago, I did not have this
issue. I could open up 20 sessions and be able to see them under Window. I
could also move one to another and be able to see all the ones that were left
as individual session.

"Lynn" wrote:

When I open multiple sessions of Excel, you cannot see all of them under the
same Window to move from one session to the other. How can this be resolved?

In addition, the formatting for color will change on 1 sheet only when I
move a session to another session as a second tab.

How can this be corrected?

Office XP has already been uninstalled and re-installed without success in
resolving this issue.



Gord Dibben

Opening Multiple Excel Sessions
 
Lynn

To prevent opening multiple sessions of Excel when you open each workbook go to
ToolsOptionsGeneral and uncheck "ignore other applications"

Then all workbooks will open in one instance of Excel and you can see them all
under Window


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 12:11:10 -0800, Lynn wrote:

Prior to having my hard drive replaced a month ago, I did not have this
issue. I could open up 20 sessions and be able to see them under Window. I
could also move one to another and be able to see all the ones that were left
as individual session.

"Lynn" wrote:

When I open multiple sessions of Excel, you cannot see all of them under the
same Window to move from one session to the other. How can this be resolved?

In addition, the formatting for color will change on 1 sheet only when I
move a session to another session as a second tab.

How can this be corrected?

Office XP has already been uninstalled and re-installed without success in
resolving this issue.




Lynn

Opening Multiple Excel Sessions
 
Gord,

That box was already unchecked. I checked, closed and unchecked again. I was
able to get 11 of the 12 to show up under 1 Window. Still a problem. I am
just perplexed. I am beginning to think that the issue might be a Windows
issue rather than an Excel issue. Thanks for your input

"Gord Dibben" wrote:

Lynn

To prevent opening multiple sessions of Excel when you open each workbook go to
ToolsOptionsGeneral and uncheck "ignore other applications"

Then all workbooks will open in one instance of Excel and you can see them all
under Window


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 12:11:10 -0800, Lynn wrote:

Prior to having my hard drive replaced a month ago, I did not have this
issue. I could open up 20 sessions and be able to see them under Window. I
could also move one to another and be able to see all the ones that were left
as individual session.

"Lynn" wrote:

When I open multiple sessions of Excel, you cannot see all of them under the
same Window to move from one session to the other. How can this be resolved?

In addition, the formatting for color will change on 1 sheet only when I
move a session to another session as a second tab.

How can this be corrected?

Office XP has already been uninstalled and re-installed without success in
resolving this issue.






All times are GMT +1. The time now is 01:55 PM.

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