'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Convert an Excel Add-In File Back to a Normal Workbook
Question details
The user accidentally saved an Excel workbook as an Add-In, preventing standard access.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to view and edit data in an Excel file that was mistakenly saved as a Microsoft Excel Add-In (.xlam or .xla).
- Observed behavior
- The file opens as a blank screen or remains entirely hidden in the background because its IsAddin property is set to True.
Before proceeding, ensure that the hidden Add-in file is currently open in your Excel application, even if you cannot see it on your screen.
Modify the IsAddin Property via the Visual Basic Editor
Use this method to make the hidden Add-In visible again so you can save it as a standard workbook format.
When an Excel file is saved as an Add-In, its IsAddin property is automatically changed to True, which hides the workbook from the standard user interface. By reverting this property in the Visual Basic Editor, you can restore standard visibility and functionality.
Press Alt + F11 on your keyboard to launch the Microsoft Visual Basic for Applications (VBA) Editor.
Locate the 'Project Explorer' panel on the left side. Find your specific Add-in project in the list and click on its 'ThisWorkbook' object.
Look at the 'Properties' window typically located below the Project Explorer. Scroll down to find the 'IsAddin' property and change its value from True to False. Your workbook should instantly become visible in the main Excel window.
Close the VBA Editor and return to Excel. Go to File > Save As, and choose a standard format such as 'Excel Workbook (*.xlsx)' or 'Excel Macro-Enabled Workbook (*.xlsm)'.
Switch to WPS Office for a Seamless Spreadsheet Experience
If you frequently encounter complex file format issues or accidental format saves in Microsoft Excel, consider trying WPS Office. It provides a lightweight, highly compatible, and user-friendly interface to manage all your standard and macro-enabled workbooks effortlessly.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open WPS Spreadsheets: Launch the Spreadsheets module, which features an interface instantly familiar to Excel users.
- 3. Seamlessly Open Workbooks: Drag and drop your standard .xlsx or .xlsm files directly into WPS to continue your work without format compatibility issues.
Frequently Asked Questions
Why does my Excel file open as a blank gray screen?
If your file opens entirely blank with a gray background, it may have been saved as an Excel Add-In (.xla or .xlam). Excel naturally hides Add-In workbooks. You must change the IsAddin property to False in the VBA Editor to view its contents.
Can I recover macros from an Excel file saved as an Add-In?
Yes. When you change the IsAddin property back to False and make the workbook visible, all your existing macros remain intact. Just remember to save the recovered file as an 'Excel Macro-Enabled Workbook (.xlsm)'.
Where is the Project Explorer located in Excel?
The Project Explorer is located inside the Visual Basic Editor. You can access it by pressing Alt + F11. If you don't see it on the left side of the screen, click 'View' in the top menu bar and select 'Project Explorer', or press Ctrl + R.
