We help IT Professionals succeed at work.

Sorry, Excel can't open two workbooks with the same name at the same time

774 Views
Last Modified: 2016-10-17
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
Comment
Watch Question

Haris DulicInformation System/Enterprise Architect
CERTIFIED EXPERT

Commented:
Does any of them have links to each other?

Author

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?
Information System/Enterprise Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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
Haris DulicInformation System/Enterprise Architect
CERTIFIED EXPERT

Commented:
Glad that I could help

Author

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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.