Forum Discussion
Formula uses the file that doesn't exist.
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.
You absolutely right, it most likely was an Outlook attachment. Strange thing is that the formula still works, even though I am not able to locate the file with the actual data. I copied the spreadsheet in another .xlsx file, I copied the formula in another cell, I tried to change parameters in the formula and it gives the right numbers. I am not worried about the data, since I have them, but I was just wondering how it could be that the data comes from non-existing file. I checked the Content.Outlook folder, there is no such a file there. I tried search option for the file in Windows directory, it returns nothing, but the numbers still come from nowhere. That's surprising!