Aggregate values not appearing in excel

Eric Davis

When saving a report that has aggregation as .xlsx, the values are blank when spreadsheet is opened. However, if you just run it and choose "Open" instead of "Save", the values appear.

Any suggestions?

Eric Davis

Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

Chad Montgomery

@Eric Davis said:
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

To confirm why that is, when live formula's are enabled on export to Excel, aggregations typically will be an Excel formula instead of a static value. Protected view in Excel prevents formula's from calculating until you enable editing. If you were to disable live formula's, you'd see the aggregations without enabling editing.

Eric Davis

@Chad Montgomery said:

@Eric Davis said:
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

To confirm why that is, when live formula's are enabled on export to Excel, aggregations typically will be an Excel formula instead of a static value. Protected view in Excel prevents formula's from calculating until you enable editing. If you were to disable live formula's, you'd see the aggregations without enabling editing.

Thanks for the explanation.

Eric Davis

Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

Chad Montgomery

@Eric Davis said:
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

To confirm why that is, when live formula's are enabled on export to Excel, aggregations typically will be an Excel formula instead of a static value. Protected view in Excel prevents formula's from calculating until you enable editing. If you were to disable live formula's, you'd see the aggregations without enabling editing.

Eric Davis

@Chad Montgomery said:

@Eric Davis said:
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.

To confirm why that is, when live formula's are enabled on export to Excel, aggregations typically will be an Excel formula instead of a static value. Protected view in Excel prevents formula's from calculating until you enable editing. If you were to disable live formula's, you'd see the aggregations without enabling editing.

Thanks for the explanation.