AnsweredAssumed Answered

I/O timeout or #value datalink impact on calculations

Question asked by SaifGhadhban on Jan 10, 2016
Latest reply on Jan 13, 2016 by jaroberts



I have a workbook that imports data with PI datalink, however sometimes we get I/O timeout or #value this effects all the formulas we have in the sheet such as average


Would it be possible to use averageif function if we have I/O timeout or #value errors for the following code?


Range("I7").Value = "=average(G4:G" & lastrow & ")"


I tired to add it to average values above zero however it didnt work


Range("I7").Value = "=averageif(G4:G" & lastrow & ",>0)"