Aggregate values not appearing in excel
Best Answers
-
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.
1 -
@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.
Warning No formatter is installed for the format ipb0 -
@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.
0
Answers
-
Found the issue. I had to uncheck the protected view options in excel. Now it works as expected.
1 -
@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.
Warning No formatter is installed for the format ipb0 -
@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.
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management