I opened an Excel file that's stored in the LAN. A cell in the file is linked to '\\LAN folder\LAN subfolder 1\LAN subfolder 2\Received\[Sheet Name]tab_name'!$A$1. The formula works fine.
I wanted to find the source file [Sheet Name]. I went to the LAN folder, then LAN subfolder 1 and LAN subfolder 2. However, there was no more folder (let alone something named "Received") under LAN subfolder 2, just a few spreadsheets. None of the spreadsheets was named [Sheet Name].
So where did \Received\[Sheet name] come from?
I wanted to find the source file [Sheet Name]. I went to the LAN folder, then LAN subfolder 1 and LAN subfolder 2. However, there was no more folder (let alone something named "Received") under LAN subfolder 2, just a few spreadsheets. None of the spreadsheets was named [Sheet Name].
So where did \Received\[Sheet name] come from?
