Enabling a larger worksheet size for Excel 2007
Let's say that you have built a report that primarily is a data extract. It produces more than 65,000 rows. When users run it in Excel 2007, it is spread across multiple sheets though Excel 2007 supports over a billion rows. Let's see how to fix by changing server settings.
Getting ready
You require admin rights for this so you can change service settings.
How to do it...
In this recipe we will see how to enable a larger Excel 2007 worksheet by changing IBM Cognos BI server settings.
- Open Cognos Administration from Connection Portal and go to Configuration | Dispatcher and Services.
- Click on the dispatcher ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
