Number of columns and rows exceeds the maximum in Excel
The number of columns is restricted to 255. If the schedule exceeds this number, the following situations can occur:
-
Schedule without local modeling
All of the columns come from the Financial Consolidation schedule. When you open the schedule, a message appears, indicating that the number of columns exceeds the maximum in Excel. The schedule will therefore be displayed in HTML format.
-
Schedule with local modeling
The Excel limit of 255 is exceeded when the Financial Consolidation columns are added to the local modeling columns. A message appears, telling you that the limit has been exceeded and that the schedule will be opened in Excel Web Schedules without the local modeling enhancements.
The number of rows is restricted to 65,536. If your schedule contains more than 65,536, the following scenarios are possible:
-
Schedule without local modeling
All of the rows come from the Financial Consolidation schedule. When you open the schedule, a message appears, indicating that the number of rows exceeds the maximum in Excel. The schedule will therefore be displayed in HTML format.
-
Schedule with local modeling
The Excel limit of 65,536 is exceeded when the Financial Consolidation rows are added to the local modeling rows. A message appears telling you that the limit has been exceeded and that the schedule will be opened in Excel Web Schedules without the local modeling enhancements.
