1 Reply Latest reply on Jun 23, 2014 8:08 PM by KKT

    HsGetValue shows #NEED REFRESH





      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)