Avatar of Eric Barker
Eric Barker
 asked on

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
Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Eric Barker

8/22/2022 - Mon
Haris Dulic

Does any of them have links to each other?
Eric Barker

ASKER
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
Haris Dulic

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
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.
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
Eric Barker

ASKER
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.

EB
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!
Walt Forbes
Haris Dulic

Glad that I could help
Eric Barker

ASKER
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.