Google Sheets – What’s Taking CPU Time

google sheets

I have a complex Google Sheet, and the gray bar on the top right takes a long time to complete. Is there a way to see what the sheet is calculating to pinpoint down what part of the sheet is taking up the CPU time?

Best Answer

No, there is no CPU profiler provided by Sheets. The following may help locate the issue:

Make a copy of the spreadsheet
"Freeze" some of its calculated values (select a range, press Ctrl-C, then Ctrl-Shift-V, overwriting formulas with static values).
Observe the effect on the performance of the spreadsheet.
Repeat for a different group of formulas.

Short answer

The recalculation speed depends mostly on the local resources.

Explanation

On Google Sheets, most of the built-in functions are run on the client (browser), just some functions like IMPORTHTML, IMPORTXML, IMPORTDATA, IMPORTRANGE, GOOGLEFINANCE require access to the Internet in order to be executed, as well the custom functions because they require Google Apps Script which is run on the Google servers.

You could use something called Google Chrome timeline-tool to check your specific case.

Best Answer

Related Solutions

Google Sheets – Formula to Return Time Difference Without Displaying 0

Google Sheets – Where Does the Calculation Take Place?

Short answer

Explanation

Related questions

Related Google Docs Editors help articles

Related Topic