Multiple copies of excel

  • Thread starter Thread starter Mike Jacobson
  • Start date Start date
M

Mike Jacobson

Everytime I open a new worksheet Excel opens a new copy. As a result I
cannot copy or link from one worksheet to another. I know there is a
setting somewhere to correct this, I found it in Excel XP but I forgot how I
did it, but I am now in Excel 2007.
 
If you open excel, then use Office button|Open, then things work ok, right?

If yes, then I'd try this:

Tools|Options|General|Ignore other applications (uncheck it)
(xl2003 menus)

Office button|Excel Options|Advanced category|General section|
uncheck Ignore other Applications
(xl2007 menus)

If that doesn't work, try re-registering excel:

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.
 
Hi,

I can't get multiple copies of Excel by adding a worksheet. Try pressing
Shift+F11 and let us know what happens.

If on the other hand you mean by adding a new Workbook, not Worksheet then
try Dave's suggestion. If this is the problem, how are you opening a new
workbook:
1. Pressing Ctrl+N
2. Choosing Office Button, New...
3. Clicking the New button on the QAT
 
Back
Top