D
david
I have created a Source file containing information that I
want to access from multiple Destination files. From time
to time I will need to add rows or columns to the Source
file and have this reflected in the Destination workbooks.
I am using Validation lists and Defined names to do this
and it works OK. As long as the two workbooks are open any
changes to the Source file are reflected in the
Destination file. But if the Destination is closed while
the Source file is being changed, when the Destination is
open the reference in the Defined Name has not changed
even if the program asks for me to 'update'.
I have tried changing the Refer to reference in the Define
Name box to eliminate the $ sign(that was worse) and using
the Offset function and I think that I have all
appropriate boxes checked in the Edit/Links and
Tools/Options/Edit and Calculations menus but it just
won't update as the info in Help says it should.
I'd appreciate any help.
want to access from multiple Destination files. From time
to time I will need to add rows or columns to the Source
file and have this reflected in the Destination workbooks.
I am using Validation lists and Defined names to do this
and it works OK. As long as the two workbooks are open any
changes to the Source file are reflected in the
Destination file. But if the Destination is closed while
the Source file is being changed, when the Destination is
open the reference in the Defined Name has not changed
even if the program asks for me to 'update'.
I have tried changing the Refer to reference in the Define
Name box to eliminate the $ sign(that was worse) and using
the Offset function and I think that I have all
appropriate boxes checked in the Edit/Links and
Tools/Options/Edit and Calculations menus but it just
won't update as the info in Help says it should.
I'd appreciate any help.