Limits on view and workbook size

In a single view, CPM has a limit of up to 256 data columns and 65,530 rows (depending on the number of off-grid dimensions). You can have up to 42 views in a workbook. If you have more than 3 to 5 views in your workbook, we recommend you not automatically refresh the views when the workbook is open. This improves performance on open, but you need to inform the users they must perform a manual refresh on each worksheet when they open the workbook.