Posted 11 July 2018, 4:04 am ESTExcel 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").Valueon a cell with an external reference, I get always get either zero or 4 (no idea why it returns 4, the actual value is nothing like 4). I can understand why Documents for Excel doesn't support dynamic update of cells with external references, but it seems like it should be able to provide the cell's cached value. Is this possible?