A
AlexD
I need to work with two Excel books. The first MainBook
consist of a list of products (different sheets with
around 100 rows - the first column is the list of products
the rest of the columns are with diff. calculations).
Every product is linked with another book (product1 with
book1, product2 with book2, ...). From the other hand,
some cell from these book1, book2,..., book100 is linked
with the MainBook. I don't have any choice but use and
maintain it. Some users can use and modify book1, ...
book100.
When they do some modifications such as adding or deleting
rows some links can be corrupted or refer to wrong cells.
This is why I decided to use VLOOKUP instead of using
usual links. Everything is fine - there are no corrupted
links and no wrong refferences because VLOOKUP is looking
for specific cells. But, it's working very slow when user
is openning the MainBook with link update.
I'm using the version such as VLOOKUP("A1",Path!
A1:C1,4,FALSE).
I heard that using range instead of A1:C1 can make it
faster. But, logically there should be no difference.
I would appreciate any advice.
Thanks advance.
consist of a list of products (different sheets with
around 100 rows - the first column is the list of products
the rest of the columns are with diff. calculations).
Every product is linked with another book (product1 with
book1, product2 with book2, ...). From the other hand,
some cell from these book1, book2,..., book100 is linked
with the MainBook. I don't have any choice but use and
maintain it. Some users can use and modify book1, ...
book100.
When they do some modifications such as adding or deleting
rows some links can be corrupted or refer to wrong cells.
This is why I decided to use VLOOKUP instead of using
usual links. Everything is fine - there are no corrupted
links and no wrong refferences because VLOOKUP is looking
for specific cells. But, it's working very slow when user
is openning the MainBook with link update.
I'm using the version such as VLOOKUP("A1",Path!
A1:C1,4,FALSE).
I heard that using range instead of A1:C1 can make it
faster. But, logically there should be no difference.
I would appreciate any advice.
Thanks advance.