external references still working on computers that do not have access to linked excel file

Dear Experts:

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_2015). 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' ...
10-100-04-07
10-100-34-07
10-104-41-07
... 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 for me.  

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.

Regards, Andreas

Price-List-exernal-links-still-working.x
Andreas HermleTeam leaderAsked:
Who is Participating?
 
ProfessorJimJamCommented:
This is a known thing in Excel.  when you use a reference in a formula, somehow Excel workbook keeps that information used in the formula, even if you delete the source data

to see how this works. there is good explanation in the video https://www.youtube.com/watch?v=-0cDSt0Io40 
which shows how the workbook formula retains the data from a deleted or closed external reference.
0
 
Martin LissOlder than dirtCommented:
You can go to Data->Edit Links->Break Link to stop that from happening.
0
 
Ejgil HedegaardCommented:
Go to Excel settings, advanced, and remove the mark for "Save values for external links".
0
 
Andreas HermleTeam leaderAuthor Commented:
ProfJimJam: thank you very much for this tip. I am so glad that this forum, EE, has a solution to all problems there are. Again, thank you very much for your swift and professional help.

Martin: Ok, you are right, but as you know, this results in the formulas being converted into static values. Anyhow, thank you very much for bringing this to my attention.

Ejgil: that is a very good piece of advice. Thank you very much for bringing this to my attention. I really appreciate it.

Regards, Andreas
0
 
Andreas HermleTeam leaderAuthor Commented:
Dear all,

thank you very much for your great and professional support. Every advice and solution you gave me is valuable, I would like to award 500 points to each of you, but regrettably this is not possible.

Again, thank you very much for your superb support. This form is just great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.