smartView need to refresh twice to show zero values

In a smartView file with HSGETVALUE formulas we have a divide by factor formula.  For one particular user with office 2010 and excel 2013, they need to click "Refresh" twice to get cells with a zero value not to say #value.  Other users can refresh just once and it shows the zero.   Is there some excel setting that will help this so that one refresh will work?

Formula example is below and the HSgetvalue will = zero and the /$B$7 points to a cell with 1000 in it to show data in thousands.

=(HsGetValue("Scenario#"&$B$8,"Year#"&$B$10, "View#"&$B$12, "Entity#"&$A75, "Value#"&$B$2,"ICP#"&$B$1, "Custom1#"&$B$3,"Custom2#"&$B$4,"Custom3#"&$B$5,"Custom4#"&$B$6,"Account#"&$B$9,"Period#"&S$11))/$B$7