I got a price list that receives parts of the cell values from an external reference (linked excel file on my C: drive: C:\Prices\Price_List_May_2
015). The linked excel file delivers cell entries because of lookup formulas
If I send my price list to somebody else who does not have access to the linked excel file, the lookup formulas still work, this is so weird and crazy. I got no idea how this is possible.
Can somebody help me solve this riddle.
Please enter the following articles in the Column 'Article No'
... and you will see the entries for description, unit and price will be retrieved from the linked excel file although you do not have access to it.
How come? this is a complete riddle
Please find attached the sample file for your convenience. The sheet is protected, but it can be easily unprotected since there no password protection.
Help is much appreciated. Thank you very much in advance.