OVERVIEW

Cryptosheets power templates often contain custom functions that require a minimum version of Office or Excel to be installed. If you load a template but the data doesn't pull through, try using the below steps to troubleshoot and resolve.

❓  TIP  Look for "Hover for help" and "legend" cells in templates for a quick reference

SCENARIO:

⚠️ PROBLEM
I loaded my template but the formulas are broken, say #NAME? or show another error?

  • We create templates using the latest version of custom functions but not everyone has the latest version of Office or Excel installed. 
  • To prevent destabilizing your Excel environment Microsoft may automatically convert the Cryptosheets custom function into a dummy static placeholder if it thinks it detects an incompatible version or you're logged into an Office account that hasn't been upgraded.

😄 SOLUTION
Find the active formula cell  in the template (usually color coded light gray with orange text*) and adjust the formula syntax to read correctly as shown

ADDITIONAL RESOURCES

👉 For Microsoft Excel

👉 For Googlesheets

Cryptosheets is free to sign up and start using now. What are you waiting for?

Signing up for Cryptosheets is free --> Get crypto data in 30 seconds or less

Website  |  WebApp  |  Excel  |  Googlesheets  |  Help Center  | Blog  | Twitter
______________________________________________________________

TAGS : formulas, custom functions, troubleshooting, error, help, no data, #NAME? #N/A, excel, googlesheets, spreadsheet, template, CS.QUERY, CSQUERY

Did this answer your question?