A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

opening multiple Excel 2007 files in same window (instance)



 
 
Thread Tools Display Modes
  #1  
Old October 7th, 2009, 06:59 PM posted to microsoft.public.excel.misc
Georgia
external usenet poster
 
Posts: 32
Default opening multiple Excel 2007 files in same window (instance)

Hi,

Whenever I open a file from outlook via link or an attachment, the files
open in different window (instance). When this happen, I cannot use my
ctrl+tab to switch between different files or when I do vlookup between 2
different files, it will not work. How do I go about fixing this?

Thanks!
  #2  
Old October 7th, 2009, 08:32 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default opening multiple Excel 2007 files in same window (instance)

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Uncheck "Ignore other applications"
(xl2003 menus)

or
Office Button|Excel Options|Advanced|General|Uncheck "Ignore other applications"

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

=============
If that fails, you can always save the attachment and then use File|Open (or
xl2007's equivalent) to open that file.

GEORGIA wrote:

Hi,

Whenever I open a file from outlook via link or an attachment, the files
open in different window (instance). When this happen, I cannot use my
ctrl+tab to switch between different files or when I do vlookup between 2
different files, it will not work. How do I go about fixing this?

Thanks!


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.