Vlookup info being used without vlookup table attached?

G

Guest

Hi there,

I've createed a vlookup table in workbook1 that links with
workbook2 which utilizes the vlookup table in workbook1.

However if I email workbook2 to someone without workbook1
why is it that when this person types in the information
required by the vlookup table that the information thats
in workbook1 appears in workbook2? When they open
workbook2 they are told that not all links can be updated
(because workbook1 is missing) I don't understand! And is
there anyway that I can prevent this?

Thanks so much for your help and I hope this makes sense!

charlie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VLookup with 2 Workbooks 0
Searching in another workbook for a string and returning with the contents of the cell next to it. 1
Addning info from diffrent workbooks using VBA 4
Vlookup - maybe?! 7
vlookup data hidden within worksheet 0
Excel 2007 Vlookup Using New Table Syntax 2
Using VLOOKUP to look up info from Access 0
help to in setting up a proper Vlookup table and formula 4

Top