Issue
- An XLSX report is created using a triggered Notification in EBO.
- When the report should be opened in Excel an error appear "Excel cannot open the file ..." and the report can not be opened.
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Workstation
- Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013 Office for business
Cause
Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't been used (especially entire rows and columns) can cause your workbook's file size to grow quickly. This can slow down not just Excel, but the overall performance of your computer when you have an excessively formatted worksheet open. Excessive formatting can also cause printing problems in Excel.
Resolution
Use the Clean Excess Cell Formatting command, available on Excel's Inquire tab in Microsoft Office 365 and Office Professional Plus 2013.
Important: You may want to make a backup copy of your file before cleaning the excess cell formatting because there are certain cases where this process may make your file increase in size, and there is no way to undo the change.
If you don't see the Inquire tab in Excel, do the following to enable the Inquire add-in:
- Click File > Options > Add-Ins.
- Make sure COM Add-ins is selected in the Manage box, and click Go.
- In the COM Add-Ins box, check Inquire, and then click OK.
The Inquire tab should now be visible in the ribbon.
To remove the excess formatting in the current worksheet, do the following:
- On the Inquire tab, click Clean Excess Cell Formatting.
- Choose whether to clean only the active worksheet or all worksheets. After excess formatting has been cleared, click Yes to save changes to the sheets or No to cancel.
See Microsoft support topic: Clean excess cell formatting on a worksheet
