I've installed latest version of MarketXLS but now all formulas return #NAME.

Discussion in 'FAQ' started by marketxls, May 9, 2017.

I've installed latest version of MarketXLS but now all formulas return #NAME.

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    1) First, check in the function browser if you see the MarketXLS functions.

    upload_2017-5-9_3-8-21.png

    If you see these functions that mean MarketXLS functions are installed properly. If not, uninstall all previous versions of MarketXLS and install it again.

    2) If you have the functions but still they result in #Name. check if =Last("MSFT") works fine. If it does that means the specific functions you are using may have an issue.

    3) If even that returns a #Name then do a complete uninstall by going to the control panel and install it again from the MSI file provided.

    This video shows how to uninstall and install MarketXLS. And issues you may face while upgrading.

     

Share This Page