Workbook Limitations

Note

You may find yourself unable to clear the cache or have formulas that keep loading for an extended period of time. Refreshing the browser (F5 on the keyboard) will reset the system back to its original state. Make sure to save any changes on the worksheet before proceeding, as pending changes will be discarded and the caches cleared of all their content.

Please be aware that this release of the workbook has the following limitations:

  • In the Formula Wizard, if you create a formula with a Date filter, you must enter the value in this format: yyyy-mm-dd. This limitation does not apply when referencing a cell.

  • Using measures as filter may cause a decrease in performance.

  • When exporting a workbook using the Export Templates feature, you must select at least one data model if the workbook does not contain any formula.

  • SQL queries returned by the workbook cannot exceed a 5-minute execution time nor volumes higher than 500,000 rows. If these limits are reached, the formulas will fail with an error.

  • Newly created global variables are not immediately available in the Functions tool. You need to log out and log back in to have the updated list.

  • The page orientation set in the Page Layout tab is not applied to the Layout section when the Print option is selected for a workbook.

  • The maximum file size limit when importing a workbook is 100 MB.