1 person found this helpful
I resolved issue by running Function Builder from smart view pannel and not from MS OFFICE Ribbon.
One thing to check, confirm in your HsGetValue() formula that the connection name is exactly as you saved it in your Private Connections. If it is a shared worksheet (or you opened it from an email, or shared network drive, sometimes the connection name gets out of whack). Then of course, make sure you are connected. When you open and close Excel you will need to reauthenticate.