opening multiple Excel 2007 files in same window (instance)

G

GEORGIA

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!
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top