multiply workbooks opening in 2003

W

wendy

I copied info from one workbook to a new workbook and now whenever I open the original workbook a new workbook opens. someone else pasted cells from one workbook to another and now both workbooks open at the same time. If you close one the other opens. They are not linked in any obvious way. These files were 2000 files orignally.
 
D

Dave Peterson

First, just a check to make sure it isn't the same workbook with a second window
open.

When you look at the title bar, do you see:

book1.xls:1
or
book1.xls:2

If yes, then select the window you don't want to see anymore and hit ctrl-W.
Then save the workbook (for the next time).

If that wasn't it, is there a "helpful" macro running?

Start excel in safe mode and see what happens:

Close excel
windows start button|Run
excel /safe

File|Open your workbook and see what happens.

If the problem didn't occur, then maybe it's a macro contained in that workbook
that's causing the problem.

You could look for macros and see what's happening.
 
Top