Disappearing values

Occasional Visitor

Good afternoon,  I am using an iferror coupled with vlookup formula to reference a workbook and produce a value.  All is well until I close the referenced workbook.  Once I close it the values disappear.  When I check the formula all looks good.  


I have tried using the formula by modifying the iferror from "" at the end to 0 and the issue persists.  I tried removing the iferror portion of the formula and it still does this.


all workbooks are in the same server file and is till doing this.  This just started happening yesterday, I have never had an issue like this before.  Has anyone experienced this and have you found a solution?  I have not been successful in any other platform to find a solution.

0 Replies