Solved: Two Excel Workbooks open at same time

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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?
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,645
You must have coded something in them, this doesn't happen automatically
 

WendyM

Retired Trusted Advisor
Joined
Jun 27, 2003
Messages
4,042
Hi bass,
What version of Excel are you using?
 

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.
 

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?
 

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?
 

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?
 

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.
 

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top