'%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)
Cannot Save XLSM as XLS on Chromebook: Causes and Solutions
Question details
The user is unable to save or convert a macro-enabled XLSM workbook into the older Excel 97-2003 (XLS) format using their Chromebook.
- Product
- Microsoft Excel
- Device & OS
- Chrome OS
- Scenario
- Attempting to change the file format of an existing macro-enabled workbook to a legacy XLS file format on a Chromebook device.
- Observed behavior
- The application prevents the conversion or lacks the option to save the XLSM file as an XLS file.
Verify whether you are using the Excel web app or the Android app on your Chromebook, as mobile and web versions have distinct format limitations. Also, note that converting a macro-enabled file to a standard format may remove existing VBA macros.
Convert the File Using Desktop Excel on Windows or macOS
Since Chromebooks use the web or mobile versions of Excel which lack advanced format conversions, use a standard desktop environment to process the file.
Chromebooks rely on specialized operating systems and primarily run the web-based or Android mobile versions of Microsoft Office. These simplified versions often do not support every conversion path, especially when dealing with macro-enabled XLSM files and legacy XLS formats.
Upload your XLSM file to a cloud storage service like Google Drive or OneDrive, or transfer it to a USB flash drive.
Access the file on a Windows PC or Mac that has the full desktop version of Microsoft Excel installed.
In desktop Excel, click 'File' > 'Save As'. Choose your save location, and in the 'Save as type' dropdown menu, select 'Excel 97-2003 Workbook (*.xls)'.
Save the converted file and transfer it back to your Chromebook.
Verify Format Limitations with a New Workbook
Test whether the issue is specific to the current XLSM file's contents or a general limitation of the Excel app on your Chromebook.
Use WPS Office for Better Compatibility on Chromebooks
Microsoft Excel on Chrome OS often relies on web or mobile versions with limited format support. WPS Office offers a robust application for Chromebooks that handles a wide range of formats seamlessly, making it a powerful, lightweight, and free alternative to Microsoft Office.
- 1. Install WPS Office: Open the Google Play Store on your Chromebook, search for WPS Office, and click Install.
- 2. Open the XLSM file: Launch WPS Office and open your existing XLSM workbook from your local storage or cloud drive.
- 3. Save as XLS: Click the 'Menu' or 'File' icon, select 'Save As', and choose 'Microsoft Excel 97-2003 (*.xls)' from the format dropdown list.
Frequently Asked Questions
Why can't I save macro-enabled files (XLSM) directly on Excel Web?
Excel for the Web has restricted capabilities regarding macros. While you can view workbooks containing macros, web browsers do not support running VBA. Consequently, advanced conversions and saving macros into legacy formats like XLS are often disabled to prevent corruption and data loss.
Are macros supported on Excel for Chromebook?
No. Chromebooks use the Android or Web versions of Excel, neither of which supports running, creating, or editing VBA macros. You need the full Windows or macOS desktop version of Excel to manage macros.
Will I lose data when converting XLSM to XLS?
Yes. The legacy XLS (Excel 97-2003) format does not handle macros in the same isolated manner as the newer XLSM format. When you convert the file, you will be warned that macro features and any new formulas or formatting introduced in modern versions of Excel may be permanently lost.
