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...
It appears the link was created from an Excel file opened from an Outlook attachment. The attachment is downloaded to this hidden folder before opening. The user ('username' in your example?) should have saved the attachment before creating any links.
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.