Why did you get disabled?
👉 What to do if you get an email like this:
"We have detected a large amount of error requests in your account, and, as a precautionary measure, have disabled your account. If you believe this to be an error, please contact
firstname.lastname@example.org for assistance. Sincerely, The Cryptosheets team"
Don't worry - most often it's an accident but it's often something small like the syntax of a formula that just needs adjusting
Read below for more information actions to take
last updated 7/31/2021
😦 Here are some of the potential reasons:
You went over your allowed quota limits for your subscription tier
You were receiving a large amount of errors as a percentage (%) relative to your overall quota
Example scenarios that could trigger auto disable:
1) You have 1,000 requests per month and 200 errors or 20% of your requests are errors =
2) You have very little request activity and suddenly have an increase of more than 3-500% =
3) You suddenly start sending hundreds or thousands of requests per second =
4) You are continuously sending multiple requests per second but your free forever subscription has a maximum request concurrency of 1 per second =
5) You are automatically backing up your Google Sheet (to Google Drive), Sharepoint or One Drive using AutoSave (which is enabled by default*) on a regular basis so although your sheet wasn't open in the browser, it could have still been refreshing the data in the background every time Google was opening it to save the backup copies. Once you uninstall the app from the backup sheet, everything should return to behaving as expected.
"AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work.
AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online." - Microsoft
❓ What happened?
When you combine API data with the power of spreadsheet formulas sometimes formulas can 'go wrong' or accidentally trigger.
Sometimes having multiple linked sheets, workbooks or tabs can set off multiple cascading triggers you may not realize
You may have lost track of your quota usage and simply surpassed your limit
Example causes that could trigger auto disable:
You have multiple Cryptosheets functions that are directly or indirectly linked to cells with volatile functions like =NOW(), =TODAY() =BNOW(),
👉 Using volatile functions including
=RAND(), =RANDBETWEEN(), =OFFSET(), =INDIRECT(), =INFO() and =CELL()`cause the entire workbook to refresh all cells on any* state change
⚠️ DO NOT use them with Cryptosheets functions as they will cause errors and rapidly consume your request quota ⚠️
2) You are repeatedly sending incorrect symbol, or exchange asset pairs (which result in errors)
3) You are repeatedly using incorrect parameters with custom functions (ie using
exchangefor =CS.EXRATE when those aren't valid parameters)
4) You have existing VBA macros, custom Google App Scripts or similar programmatic triggers setup
5) You are using a custom function that that your subscription tier doesn't have access to (ie =CS.TIME)
Entering new data (if Excel is in Automatic recalculation mode, described later in this topic).
Explicitly instructing Excel to recalculate all or part of a workbook.
Deleting or inserting a row or column.
Saving a workbook while the Recalculate before save option is set.
Performing certain Autofilter actions.
Double-clicking a row or column divider (in Automatic calculation mode).
Adding, editing, or deleting a defined name.
Renaming a worksheet.
Changing the position of a worksheet in relation to other worksheets.
Hiding or unhiding rows, but not columns.
👉 Quick VBA Example Using Volatile Functions + Solution
"I have a very complex workbook that contained multiple NOW() and TODAY() references and as it grew in size through the year the macro that ran transaction posting begin to take longer and longer."
I replaced all references to
TODAY()with a pointer to a cell in my TBL worksheet named NVDate (Non-Volatile Date).
Then I added the following code to the
Private Sub Workbook_Open()
‘Seed NVDate to eliminae volatile Today() and Now() functions
TBL.Range(“NVDate”).Value = Date
"The gain in speed was astounding. A transaction that had been taking 9 seconds to post was now running in less than a second."
➡️ Next Steps:
Make sure you understand what caused the auto disable first
--> change or adjust any formulas that need it or you will simply be disabled again
You are responsible for tracking your own quota usage 👉 you can do that anytime and in real time from within the add-in side panel
(tutorial here: https://intercom.help/cryptosheets/en/articles/3712846-see-your-subscription-usage-in-real-time)
Upgrade your subscription to raise your quota limit and avoid being disabled or wait until the monthly period has rolled over
You can upgrade from the settings > billing section inside the add-in
(tutorial here: https://intercom.help/cryptosheets/en/articles/1769408-how-can-i-upgrade-my-subscription-plan )
You can also upgrade from the webapp or directly from the website here https://cryptosheets.com/pricing
Contact us via email or chat support
Cryptosheets Docs Portal
Providers 👉 https://docs.cryptosheets.com/providers
Endpoints 👉 https://docs.cryptosheets.com/providers/cryptocompare (or any provider)
Functions 👉 https://docs.cryptosheets.com/functions
Templates 👉 https://docs.cryptosheets.com/templates
Resources 👉 https://docs.cryptosheets.com/resources
Help Center 👉 https://intercom.help/cryptosheets/en/
Cryptosheets - Resource List
TAGS: disabled, enable, exhaust, error, subscription, quota, exhausted, error, disabled, excessive, usage, refresh, autorefresh, update, refresh data, save, autosave, backup, google drive, gsuite drive, sharepoint, onedrive, one drive, workbook calculation, excel manual refresh, vba, detected a large amount of error requests in your account, precautionary measure, have disabled your account, #NAME, subscription level, billing, account, queries, errors, deleted, destroyed, upgrade, downgrade, email@example.com, help, wtf, error, timeout, support, #volatile, #volatile formulas, #volatile function, #=NOW, #=OFFSET, #=INDIRECT, =RAND, #=INFO, #=CELL, #=TODAY, #=BTODAY