I have just a little question about my spreadsheet's power. Because I made a huge sheet file with many calculations and many function apps script (I have 7 500 rows and 7 function in apps script). So I would like to know if there exists a limit size for the sheet files, and if it exists, is my file too large?
CodePudding user response：
According to this page (the numbers are increasing in time): https://gsuitetips.com/tips/sheets/google-spreadsheet-limitations/
https://support.google.com/drive/answer/37603?hl=en
Google Spreadsheets are extremely powerful and convert very well from Excel, but they do have some limitations:
- Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets
- 40,000 new rows at a time
- Maximum number of columns of 18,278 columns
- Number of Tabs: 200 sheets per workbook
- GoogleFinance formulas: 1,000 GoogleFinance formulas
- ImportRange formulas: 50 cross-workbook reference formulas
- ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data
- Maximum string length is 50,000 characters
Quotas for the Apps Script:
https://developers.google.com/apps-script/guides/services/quotas#current_limitations
- Script runtime: 6 min/execution
- Custom function runtime: 30 sec/execution
- Simultaneous executions: 30