Troubleshooting

Why does Excel slow down when I use the functions?
If you add a lot of queries to one workbook, Excel will slow down trying to constantly update the values. A good solution for this is to turn formula calcul...
Mon, 20 Mar, 2017 at 3:45 PM
Why do I get the #NAME error?
If the functions return a #NAME error, it's probably due to Excel's security settings preventing the execution of macros. Lower the security level...
Mon, 20 Mar, 2017 at 3:49 PM
Why do I get the "Fetching data failed" error?
Most common causes for these errors are: You're trying to fetch a metric or dimension that doesn't exist (you might have misspelled the name). ...
Mon, 13 Nov, 2017 at 3:06 PM
Why do I get the #VALUE error?
If the functions return a #VALUE error, it's most likely due to either of these: Forgetting to give a value for some required parameter The val...
Mon, 20 Mar, 2017 at 3:49 PM
Why do I get errors about rate limits or timeouts when using the functions in Google Sheets?
This is due to too many functions being updated simultaneously. You can avoid this by staggering the queries so that they are not all fired at the same time....
Thu, 26 Apr, 2018 at 4:07 PM