Two files open at once (XP SP2)

Topic

New Reply

I have two Excel files that I work on a lot. I wonder why it is that I will open one file and after a while look down at the taskbar and notice that somehow the other file got opened too.

Reply | Quote

Replies

Are you opening a “workspace” instead of a file, whihc has both files linked?
Is there a macro in the one opening the other?
Do you have a toolbar button with code to the second which automatically opens it?

Steve

Reply | Quote

You’re right. Whenever I run a macro to insert a row, the other document opens. The toolbar link to the macro must refer to the other document. These documents are ledger accounts for two businesses I run and I close accounts in both at the end of the year. When I set up new worksheets at the beginning of the year using templates, sometimes I find something is missing in one worksheet and I copy it from the other. Probably shouldn’t do that. Thanks.

Reply | Quote

You’re right. Whenever I run a macro to insert a row, the other document opens. The toolbar link to the macro must refer to the other document. These documents are ledger accounts for two businesses I run and I close accounts in both at the end of the year. When I set up new worksheets at the beginning of the year using templates, sometimes I find something is missing in one worksheet and I copy it from the other. Probably shouldn’t do that. Thanks.

Reply | Quote

Are you opening a “workspace” instead of a file, whihc has both files linked?
Is there a macro in the one opening the other?
Do you have a toolbar button with code to the second which automatically opens it?

Steve

Reply | Quote