Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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
0
Eric Barker
Asked:
Eric Barker
  • 3
  • 3
1 Solution
 
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
 
Haris DjulicCommented:
Links should be under data tab defined names and there you shoud find defined ljnks
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now