Link (closed)workbook to (open)workbook

Hey

I am having trouble with a project. I am using VLOOKUP to retrieve a price of a product from another workbook
This is the formula i am using =IF(B10="";"";VLOOKUP(B10;'Q:\Veitingastaður\JónIngi\Hráefnislisti (MASTERSKJAL).xlsm'!Hráefnalisti[[#All];[Nafn]:[verð]];2;FALSE)

There is a workbook(Hráefnislisti (MASTERSKJAL).xlsm) containing all the information and will be used by many other workbooks.

I have linked them together but I need to open the other workbook every time I need to update the values.
As both of them will be password protected will that effect this process?


Here is a sample of what I am trying to do
Master file.xlsm
Worbook.xlsm



Thanks,
Jón Ingi

Originally Posted by :) Sixthsense :)

Vlookup will work with the closed workbooks.

Just press Alt+E+K and click Update Values

This dose not seem to work I keep getting #REF error where the Vlookup function is. When I press Check Status in Edit links it comes up as OK But still the reference error is there until I open the source file.

The Morefunc add-in will allow you to use the "=INDIRECT" function to reference closed workbooks.

http://www.ashishmathur.com/tag/morefunc/

Originally Posted by hoyasaxa215

The Morefunc add-in will allow you to use the "=INDIRECT" function to reference closed workbooks.

http://www.ashishmathur.com/tag/morefunc/

Other users need to be able to use it.
If they don't have the add-in then will it work?

Following SixthSense's instructions, I was able to update the values from a closed workbook. As also mentioned, I suspect the error is with your vlookup formula. If you'd like further assistance, feel free to upload the two workbooks you're working with.

Originally Posted by :) Sixthsense :)

Sorry for not paying proper attention in your formula and not seen your files also.

Without seeing your file the Vlookup formula is referring to TABLE REFERENCES and which requires the source workbook to be kept open.

Convert the TABLE REFERENCES to a normal excel RANGE REFERENCE to get rid of this issue.

Replying from mobile device.

Thank you very much for this it had been bothering me for days and I never even thought about that

This issue is now resolved, thanks to you