Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2022, 08:31 AM
coffent coffent is offline "Sorry, Excel can't open two workbooks with the same name at the same time." Windows 10 "Sorry, Excel can't open two workbooks with the same name at the same time." Office 2019
Advanced Beginner
"Sorry, Excel can't open two workbooks with the same name at the same time."
 
Join Date: Dec 2019
Posts: 40
coffent is on a distinguished road
Default "Sorry, Excel can't open two workbooks with the same name at the same time."

I changed the Excel XLSTART folder to a different location than the default (which was C:\Users\{My username}\AppData\Roaming\Microsoft\Excel\XLSTART) , and then deleted the default XLSTART folder. However whenever I start Excel, it creates an empty XLSTART folder at the default location. This in itself doesn't cause a problem.

I put a VB macro in PERSONAL.xlsb in the new XLSTART folder which adds a line to the right-click menu for all Excel workbooks.

The problem occurs when I click on the added line in any workbook. I get the message "Sorry, Excel can't open two workbooks with the same name at the same time."



What are the two workbooks with the same name? I have only one workbook open. I've done a search and the only PERSONAL.xlsb file found was the one in the new XLSTART folder I created.
Reply With Quote
  #2  
Old 09-02-2022, 06:40 PM
coffent coffent is offline "Sorry, Excel can't open two workbooks with the same name at the same time." Windows 10 "Sorry, Excel can't open two workbooks with the same name at the same time." Office 2019
Advanced Beginner
"Sorry, Excel can't open two workbooks with the same name at the same time."
 
Join Date: Dec 2019
Posts: 40
coffent is on a distinguished road
Default

I removed everything and started over again. Now the added context menu line is working as it used to. Unfortunately I have no idea why!
Reply With Quote
Reply

Tags
personal.xlsb, xlstart

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range. Syed Shabbir Excel Programming 1 09-27-2020 09:35 AM
"Sorry, Excel can't open two workbooks with the same name at the same time." =COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC") trevorc Excel 8 02-22-2018 11:28 AM
ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name." misaak Excel Programming 3 06-20-2016 07:55 AM
"Open Recent" and "More..." in Excel and Word BudVitoff Office 0 04-03-2015 09:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft