L
Lyn
I've this problem that I'm creating a form for new item
register.
This form usually will be shared by everyone in the share
drive. But some of the users tend to save a copy in their
local drive. In this case, whenever i do a update in the
reference file(for Vlookup function), the form will not be
updated.
THis is the scenerio. Person A saved the form in his local
drive.This form perform a vlookup for e.g.
1 - When he enter the brand of the item ABC in A1, the
Name of the brand will show in A2 by using a vlookup.
2 - The problem is ABC might no longer valid.
Is there any ways to solve this even if the user save
their the form in their local drive with my reference file
in the shared drive.
Please help and thanks!
register.
This form usually will be shared by everyone in the share
drive. But some of the users tend to save a copy in their
local drive. In this case, whenever i do a update in the
reference file(for Vlookup function), the form will not be
updated.
THis is the scenerio. Person A saved the form in his local
drive.This form perform a vlookup for e.g.
1 - When he enter the brand of the item ABC in A1, the
Name of the brand will show in A2 by using a vlookup.
2 - The problem is ABC might no longer valid.
Is there any ways to solve this even if the user save
their the form in their local drive with my reference file
in the shared drive.
Please help and thanks!