Posted 11 July 2018, 4:04 am EST
Excel formulas can contain references to cells in other workbooks, such
='C:\Reports\[Budget.xlsx]Annual'!B3
. If the referenced file is not present, or if external reference updates are disabled, Excel displays the formula’s most recently calculated value. You can even move the spreadsheet to another machine and it will retain the cached value. Does Documents for Excel provide any way in to retrieve this cached value? When I call something like ```sheet.Range(“A1”).Value