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


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.

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


👉 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 : #_xldudf, #udf, formulas, custom functions, troubleshooting, error, help, no data, #NAME? #N/A, excel, googlesheets, spreadsheet, template, CS.QUERY, CSQUERY, #xludf, FUNCRES, FUCNRES.XLAM, xll, #_xldudf_, #udf

Did this answer your question?