'Problem opening SSRS Report exported to XLXS on Andoid/IOS

I've got an SSRS report that has multiple grouping levels, that when exported to Excel opens just fine on my PC.

This report is being scheduled and delivered as an email attachment in XLXS format, but when you try and open it on a mobile device, you get the message 'We found a problem with some content in 'spreadsheet_name.xlsx'. Do you want us to try and recover as much as we can?'

I initially thought it was due to some of the underlying data being calculated to many decimal places (even though it was only displayed to 2), so I've fixed all that, but it still won't open without this 'recovery' message first.

How do I find out what the issue is, given that on a PC it's perfectly happy?

sql-serverexcelreporting-servicesoffice365


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions