Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two files open at once (XP SP2)

    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.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Two files open at once (XP SP2)

    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

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two files open at once (XP SP2)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •