View Single Post
 
Old 09-02-2022, 08:31 AM
coffent coffent is offline Windows 10 Office 2019
Advanced Beginner
 
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