COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: ggray on 31 Aug 2018 08:47:07 AM

Title: Cognos 11.0.11 Excel Row Count greater than 65k
Post by: ggray on 31 Aug 2018 08:47:07 AM
Trying to get Excel to extend the 65k per tab. It still provides a new tab for anything over 65k even though we are using Office 2016 and I have entered the following advanced setting/parameters-
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS=1000000 and
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET = TRUE