1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Two Excel Workbooks open at same time

Discussion in 'Business Applications' started by bass1166, Dec 24, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. bass1166

    bass1166 Thread Starter

    Joined:
    May 7, 2012
    Messages:
    7
    I have two Excel Workbooks saved as Version 9 and Version 10. When I open Version 9, Version 10 also opens. How can I prevent this?
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    You must have coded something in them, this doesn't happen automatically
     
  3. WendyM

    WendyM Retired Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,042
    Hi bass,
    What version of Excel are you using?
     
  4. bass1166

    bass1166 Thread Starter

    Joined:
    May 7, 2012
    Messages:
    7
    I am using 2003, believe it or not. I dont change things just because they are new.
     
  5. WendyM

    WendyM Retired Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,042
    Hey, Excel 2003 still works just fine. (y)

    This can happen if at some point you've inadvertently opened a new window. Try selecting the one you don't want open (Version 9, I presume) and hitting Ctrl+W. Does it close just that workbook? Then close Excel and re-open version 10. Do they both still open?
     
  6. bass1166

    bass1166 Thread Starter

    Joined:
    May 7, 2012
    Messages:
    7
    Wendy, I may have stumbled upon a clue. My next question is:
    When I open an Excel 2003 workbook and access my VBA editor, I see the code for all saved workbooks. Is there a way I can assign code to only one workbook and not all?
    Could this be why the other workbook is opening? Or am I dealing with two seperate problems?
     
  7. WendyM

    WendyM Retired Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,042
    Macros that apply to all workbooks is stored in personal.xls. If you don't want it to apply to all workbooks, you can copy the macro from personal.xls to your specific workbook and then delete it from personal.xls.

    It's hard to say whether this is your issue or not without knowing what the macro does. You can try making a copy of the workbook and then deleting any macros for that workbook. Do you still have the same problem?
     
  8. bass1166

    bass1166 Thread Starter

    Joined:
    May 7, 2012
    Messages:
    7
    Where do I find Personals.xls? Is this in the VBA editor
     
  9. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
  10. bass1166

    bass1166 Thread Starter

    Joined:
    May 7, 2012
    Messages:
    7
    Hans, "It's all in the code" doesnt help me too much as I am not a proficient coder. But thanks anyway.
     
  11. WendyM

    WendyM Retired Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,042
    From Hans' link:

    If it exists, you can find the file in the Excel startup folder.

    Windows XP
    C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART

    In Vista or Windows 7 look here
    C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART
     
  12. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    If there is code in the file, should be able to see the file opened in VBA editor.
     
  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1082249

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice