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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.