1) First, check in the function browser if you see the MarketXLS functions. 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.