Have one main worksheet, which require to update data from multiple files worksheet from different directory.
Tried using "Record Macro" to create one macro to update all muliple link, and macro work fine with all from different files worksheet, using my NT login.
When with another NT login name, Link macro cannot work, need advice to rectify this, thanks