PowerEXCEL - #NAME Error and No PowerExcel Functions - Manually Register Regasm PowerExcel.dll


If you're having an issue #NAME or not seeing PowerExcel.ExcelFunctions it may be caused by the installer being unable to register the PowerEXCEL.dll using the Regasm command.


Follow the steps below to manually register:


  • Open CMD as administrator
  • Type "cd C:\ProgramData\PowerExcel" and hit enter
  • For 64bit Excel Solution:
    • Copy and Paste the following into CMD and hit enter: "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm Powerexcel.dll /Codebase"
    • For 32bit Excel Solution: Run this "C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm Powerexcel.dll /Codebase"
  • Close and re-open excel and make a slice again