Forum Discussion
Formula uses the file that doesn't exist.
I have an .xlsx file that contains data from another excel spreadsheet like this: =VLOOKUP("8 2",'C:\Users\Username\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\EMQN5Z28\[1. HSP_2012_20...
I found one more thing, maybe that's the reason:
"Functions such as LOOKUP and VLOOKUP create and store a hidden cache of the source data within the Microsoft Excel file that can be exposed through careful manipulation of the function (e.g. manually editing the column index within the VLOOKUP function will return different values from the cache)".
Any idea how to see the whole cache content?
Not too sure how to view the cache.