Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Welcome to the Schneider Electric Global Website×
The user receives the following error when attempting to export a report to Excel from Web Reporter.
Server Error in '/reporter' Application.
Excel Rendering Extension: Number of columns exceeds the maximum possible columns per sheet in this format; Columns Requested: ###, Max Columns: 256
The user will receive the following error if attempting to test a scheduled export of the report to Excel.
ION Enterprise 6.x
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.0
Web Reporter / Web Applications Reports
This problem is not a limitation of which version of Excel you have installed, but with the "rendering extension" that comes with Microsoft Reporting Services for creating Excel files.
When you choose to export a report to Excel (either from the drop-down box in the Web Reporter UI or through a subscription), a rendering extension is used to create the Excel file. A rendering extension converts the Reporting Services report to another file format.
The rendering extension creates a .xls file that is compatible with Excel 97 and above, which means that it has to work within the limits of the older versions of Excel software. Therefore the maximum number of columns that can be in the resulting .xls file is 256.
This limitation is within the Microsoft Reporting Services code, not in ION, SPM or PME code, and therefore is beyond our control.
When generating a report that will be exported to Excel, ensure that you do not select more than 256 sources or measurements.