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
Eric BarkerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Haris DjulicConnect With a Mentor Commented:
Links should be under data tab defined names and there you shoud find defined ljnks
0
 
Haris DjulicCommented:
Does any of them have links to each other?
0
 
Eric BarkerAuthor Commented:
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?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Eric BarkerAuthor Commented:
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
0
 
Haris DjulicCommented:
Glad that I could help
0
 
Eric BarkerAuthor Commented:
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.
0
All Courses

From novice to tech pro — start learning today.