If whereas opening an Excel file, you obtain the “Sorry, Excel can’t open two workbooks with the same name at the same time” error message, the options offered on this article will show you how to. In accordance with the customers who skilled this downside, this error message happens whereas opening new in addition to present Excel information. Whereas, some customers encountered this difficulty whereas opening solely the present Excel information.
Sorry, Excel can’t open two workbooks with the same name at the same time
Use the next options to eliminate the “Sorry, Excel can’t open two workbooks with the same name at the same time” error message in Excel.
- Test for any hidden workbooks
- Rename the file
- Begin a brand new occasion of Microsoft Excel
- Open Excel in Protected Mode
- Test for duplicate Add-ins
- Transfer information from the XLSTART folder to a different location
- Restore or reinstall Workplace
Let’s see all these fixes intimately.
1] Test for any hidden workbooks
In Excel, you possibly can cover the opened workbooks. This may be achieved as follows:
- Open Microsoft Excel.
- Create a brand new file or open the present one.
- Go to the View tab.
- Click on Disguise beneath the Window group.
To unhide the workbook(s), click on Unhide within the View tab. In the event you can create a brand new workbook in Excel however can’t open the present workbook, there’s a chance that the workbook is opened however hidden. Nonetheless, should you open the file that’s hidden in Excel, you will notice an error message totally different than that in query. However you possibly can nonetheless do that repair and see if it helps.
Create a brand new workbook in Excel after which go to the View tab. Now, see if the Unhide choice is clickable or not. If sure, click on on it and choose the file(s) to unhide.
2] Rename the file
The which means of the error message is self-explanatory. Excel is contemplating {that a} file is already opened and it has the same name because the file you are attempting to open. Due to this fact, change the name of the file you might be opening. This could assist.
3] Begin a brand new occasion of Microsoft Excel
Run a brand new occasion of Microsoft Excel and see if the error message seems this time or not. Comply with the steps offered beneath:
- Proper-click on the Excel icon in your Taskbar. If Excel isn’t obtainable in your Taskbar, it’s a must to pin it there.
- Press and maintain the left Alt key.
- Click on Excel 2016. In your case, the model variety of Excel could also be totally different.
- You’ll obtain a immediate asking you to open a brand new occasion of Excel, click on Sure.
- Launch the Alt key when the Excel opens up.
Now, create a brand new clean workbook and see what occurs.
4] Open Excel in Protected Mode
In Microsoft Workplace, generally, issues happen as a consequence of conflicting add-ins. This could be the case with you, because the same factor has been reported by a number of customers who encountered this error. Open Excel in Protected Mode and see what occurs.
If the problem doesn’t seem within the Protected Mode, that you must discover out the problematic add-in. To take action, disable add-ins one after the other and see if the issue seems or not. You must disable each Excel and COM add-ins.
To disable add-ins, that you must create a brand new workbook or the present one in Excel. In the event you can create a brand new workbook, create it. If not, do that. Go to your Desktop and right-click within the empty area. Now, go to “New > Microsoft Excel Worksheet.” Now, open this new worksheet and comply with the steps offered beneath:
- Go to File > Choices.
- Choose Add-ins from the left aspect.
- Choose Excel Add-ins from the drop-down and click on Go.
- Uncheck the chosen add-ins one after the other and click on OK.
- See if the issue persists.
Comply with the same steps to search out out the problematic COM Add-in. This time it’s a must to disable COM Add-ins. Therefore, choose the COM Add-ins within the drop-down.
5] Test for duplicate Add-ins
You also needs to examine whether or not two add-ins with the same name are put in in Excel or not. If sure, these add-ins can have totally different codecs, say .dll and .xlsm. To examine this, go to “File > Options > Add-Ins” in Excel. You will note an inventory of all put in add-ins on the appropriate aspect. See if two add-ins have the same name or not. In the event you discover duplicate add-ins with the same name, disable any one among them. This can repair the problem.
6] Transfer information from the XLSTART folder to a different location
In Excel, you possibly can create add-ins by utilizing Visible Primary Editor. After that, it can save you it at any location in your system however it’s a must to choose the file sort as Excel Add-in. The saved Excel Add-in file has the .xlam extension.
To make an Excel file open robotically once you open Excel, you possibly can place it within the XLSTART folder. This folder is normally used to retailer Excel templates. However you may also use it to retailer your Excel information. In order for you your created Excel add-ins to run robotically once you launch Excel, you possibly can place them right here.
In case you have created an Excel Add-in file and it has the default name, say E book 1; and you’ve got positioned it within the XLSTART folder, it’ll begin working robotically once you launch Excel. That is the rationale why you might be getting this error message each time you create a brand new workbook in Excel. Transfer that file to a different location or change its name.
The default location of the XLSTART folder is:
%appdatapercentMicrosoftExcelXLSTART
Open the Run command field and sort the above command in it. After that, click on OK. Home windows will open the XLSTART folder robotically.
7] Restore or reinstall Workplace
If not one of the above options mounted your difficulty, restore Microsoft Workplace. Operating an internet restore will assist. If this doesn’t assist, uninstall and reinstall Workplace. However earlier than you do that, just remember to have your Workplace activation key.
I hope this helps.
Why can’t I open two Excel workbooks at the same time?
If the two Excel workbooks have the same name, you cannot open them at the same time. For this, both shut one among them after which open the opposite or change the name of one among them.
How do I open two Excel workbooks at the same time?
You may open a number of cases of Excel in addition to a number of workbooks. To take action, press the Ctrl + O keys and choose the Excel file you need to open. Alternatively, go to “File > Open.” Or, you possibly can open workbooks immediately by double-clicking on them.
Learn subsequent: Excel discovered an issue with a number of components references on this worksheet.
