Quick Fixes to Try

Modified on Thu, 14 Sep 2023 at 03:00 PM

Here are some tips when using the Excel add-in:

  • Please ensure you are using the latest version. We are constantly improving the Excel add-in.

  • For stale data, use “Force Rerun All” on the new "Nexar Supply" tab on the ribbon to force a full refresh.

  • Each login lasts for 24 hours before another login is required. You can manually trigger another login using the "Refresh Login" button.

  • If you see errors that relate to unzuthorized access, you might not have access to some of the API fields the add-in is querying. Please check all the arguments to the login function NEXAR_SUPPLY_LOGIN().

  • Check you don't have multiple workbooks/sheets open with =NEXAR_SUPPLY_LOGIN(" clientId ", " clientSecret ") formula in. This can cause Excel some confusion.

Warning : Please ensure there is only one call to NEXAR_SUPPLY_LOGIN() in your entire workbook.

Where are my client id and client secret?

Please find this guide on finding your client id/secret in the Nexar portal.

"ERROR: Unauthorized to access 'best_datasheet'. Please upgrade your Nexar subscription to include 'DATASHEETS' "

With our "Evaluation" plan, you receive all of the features included in our API to try out. Some additional features such as data sheets aren't necessarily available or included in lower plans, such as Standard or Pro. To avoid these errors, you must add optional parameters into the login formula. 

The available parameters are: =NEXAR_SUPPLY_LOGIN(" clientId "," clientSecret "," ExcludeDatasheets "," ExcludeLeadTime "). Setting ExcludeDatasheets and ExcludeLeadTime to true will exclude these premium features. 

(Note: if unspecified these values default to false)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article