1 Reply Latest reply: Jun 23, 2014 3:08 PM by KKT RSS

    HsGetValue shows #NEED REFRESH

    7cfdc603-e186-45e9-b70f-4f08190bedc8

      Hi,

       

       

      I saved the workbook after refresh the sheet which has HSGETVALUE formula using Smartview. Then next time I try to open to see the values but it shows #NEED REFRESH. Let me know how to turn-off that and see the value without refresh whenever I open the file.

       

       

      (Note: It works if I turn-off Auto calculate option in Excel but I want to keep Autocalculate)

       

       

      Regards,

      SJ