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
​support@cryptosheets.com for assistance. Sincerely, The Cryptosheets team"

  1. 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

  2. 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 = disabled
    2) You have very little request activity and suddenly have an increase of more than 3-500% = disabled
    3) You suddenly start sending hundreds or thousands of requests per second = disabled
    4) You are continuously sending multiple requests per second but your free forever subscription has a maximum request concurrency of 1 per second = disabled
    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: ​

  1. You have multiple Cryptosheets functions that are directly or indirectly linked to cells with volatile functions like =NOW(), =TODAY() =BNOW(),

    πŸ‘‰ Using volatile functions including =NOW(), =TODAY(), =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 time or exchange for =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)

ℹ️ Other Common Things that Can & Will Cause Unexpected Refresh Include:

  • 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."

  1. I replaced all references to NOW() and TODAY() with a pointer to a cell in my TBL worksheet named NVDate (Non-Volatile Date).

  2. Then I added the following code to the ThisWorkbook object:

    Private Sub Workbook_Open()
    β€˜Seed NVDate to eliminae volatile Today() and Now() functions
    TBL.Range(β€œNVDate”).Value = Date
    End Sub

"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:

  1. 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

  2. Explore our extensive help center and docs portal resources for more information

  3. 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)

  4. Upgrade your subscription to raise your quota limit and avoid being disabled or wait until the monthly period has rolled over

  5. 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 )

  6. You can also upgrade from the webapp or directly from the website here https://cryptosheets.com/pricing

  7. Contact us via email or chat support

​


Additional Resources:

https://intercom.help/cryptosheets/en/articles/3712846-see-your-subscription-usage-in-real-time
https://intercom.help/cryptosheets/en/articles/4177217-what-constitutes-a-request-for-my-monthly-subscription-quota
https://intercom.help/cryptosheets/en/articles/1769408-how-can-i-upgrade-my-subscription-plan
​

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

Exchanges (core functions) πŸ‘‰ https://docs.cryptosheets.com/metadata/exchanges
Assets (core functions) πŸ‘‰ https://docs.cryptosheets.com/metadata/assets

Help Center πŸ‘‰ https://intercom.help/cryptosheets/en/
​

Cryptosheets - Resource List

Website: https://cryptosheets.com
Web App: https://app.cryptosheets.com
Docs Portal: https://docs.cryptosheets.com
Help Center: https://intercom.help/cryptosheets/en/

Microsoft Excel: https://appsource.microsoft.com/en-us/product/office/WA104381695
GoogleSheets: https://gsuite.google.com/marketplace/app/cryptosheets/898843532532

Medium: https://medium.com/cryptosheets
Twitter: https://twitter.com/Cryptosheets_RT, https://twitter.com/1k_experiment
YouTube: https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ

​
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, support@cryptosheets.com, help, wtf, error, timeout, support, #volatile, #volatile formulas, #volatile function, #=NOW, #=OFFSET, #=INDIRECT, =RAND, #=INFO, #=CELL, #=TODAY, #=BTODAY

Did this answer your question?