close
Hi All,
I have two workbooks, One called Data.xls and the second is a template for
each branch we have.which is driven/generated from a intranet system in our
organization
The Branch WB has defined names(references) to the Data WB. The first time
i've created the templates i worked under 'My documents' folder. the users
that use both Temlates and Data files got the Defined Names reference to the
exact 'lt;My usernamegt;/My Documents' folder and get the wrong data instead of
the place where they saved the WBs.
Is there a way for Excel to reference to the local Data.xls and not to the
original folder? If not is there any Alternative?
Thanks in advance
全站熱搜
留言列表
