Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Sorry, Excel can't open two workbooks with the same name at the same time
I am getting the message: Sorry, Excel can't open two workbooks with the same name at the same time but I am trying to open a workbook with an entirely different name, names are not even close:
Name one: SSCTicketsPEB2016.xlsx
Name two: MyIncidents1.xls
(not sure why I have one extenstion of .xlsx and one of .xls though...)
Any ideas? thx
8/22/2022 - Mon
Does any of them have links to each other?
Yes, it is possible. Number one has pasted info that may contain a link to the same app info that I am pulling into Number two... But not a direct link. One note is; I don't need any links in either one of them, just viewing/copying/pasting standard text info. I guess I should add that when I open Number one I get a message that: This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have. Options are: Update/Don'tUpdate/Help. Maybe if I remove the links in Number one? How to find/remove the links in Number one?
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
I basically removed (Broke Links) all links/connections in Excel Workbook Number one, now I no longer get the message: "Sorry, Excel can't open two workbooks with the same name at the same time". Thank you for helping me figure this out and getting it Solved! I really appreciate it.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Glad that I could help
Technically I suppose the Expert bringing up the query of: "Does any of them have links to each other?" started us on the right track to solving this problem though. Thank you.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent