A
ARbitOUR
Hi there,
I have a problem with updating external content...
I have two macro enabled workbooks: one acts as a price list database
and the other as a quotation template. The quotation template draw
pricing information from the price list database using externa
references via multiple 'SUMIFS' statements (implying that the databas
price lists must be open in order to update the links). Everything work
fine...
However, when I E-mail these specific two workbooks to the end-users
need the links to automatically update when both workbooks are open
which it currently does not do
How can I change the current absolute external references to relativ
references bearing in mind that both workbooks will always be situate
in the same folder
I have a problem with updating external content...
I have two macro enabled workbooks: one acts as a price list database
and the other as a quotation template. The quotation template draw
pricing information from the price list database using externa
references via multiple 'SUMIFS' statements (implying that the databas
price lists must be open in order to update the links). Everything work
fine...
However, when I E-mail these specific two workbooks to the end-users
need the links to automatically update when both workbooks are open
which it currently does not do
How can I change the current absolute external references to relativ
references bearing in mind that both workbooks will always be situate
in the same folder