Sorry, Excel can't open two workbooks...

Hi Guys\Girls,

Can you please help me with this problem. Previously in MS Office Excel 2010 you was able to open two document's with the same name but saved in different locations of the years.

However in MS Office Excel 2013 I am unable to do this. This is very vital to the user. I have tried to do the registry changes (%1) and that has not solved the issue.

Error states as follow:  "Sorry, Excel can't open two workbooks with the same name at the same time"
Hope you can help me with the problem.

Kind Regards,
Mani :)
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John EastonDirectorCommented:
I am still using Office 2010 and it too prevents two Wordbooks with the same name being open, even when they are in different directories.  As far as I know this has been true for the last few versions of Excel at least.

As far as I know the only option available is to renew one of the files.
In Excel 2013, Go file>options>advanced. Scroll down to the "General" category and check in the box for "Ignore other applications that use Dynamic Data Exchange (DDE)".

See if that helps :)

@JEaston... a common trick pre-2013 was to open 2 instances of Excel, but to press Alt-X whilst opening the second instance.
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Open another instance of Excel and then open the file from it.  File -> Open-> 2nd File
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

@Raheman... that no longer works in Excel 2013. Just tested that as well. You cannot even SAVE a file with the same name as an already open file (of course into a different location)... but still... no same name.

Here is a bag of tricks:

But alas... most no longer work in 2013+
Would it help if you are able to change the name of the 2nd file using, for example VBA? I mean is it important that the files have the same name or more that they can be opened simultaneously?

VBA could be used to rename, open then later close and restore original name. .. would that help?
manibirdiAuthor Commented:
Hi Guys I have found the solution:

Open the first file like normal in Excel.

On the second file you want to compare (with the same file name)

1) Right click on your excel icon on your task bar.

2) Press and hold "ALT"  (on the keyboard next to windows button)

3) Click on the Excel 2013 button (Please hold alt once you have clicked the button)

4) you will be prompted by the following "Do you want to start a new instance of Excel" Press YES
5) Open the file with the same name and your problem has been solved

Please also note this works on 64bit and 32bit Excel 2013

Enjoy your day :)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
manibirdiAuthor Commented:
Found the answer
Suganya RCommented:
It was really helpful..Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.