I have created 2 linked files using Excel 2003. A source file to enter data into and a destination file for others to view, through the use of links ... this part works fine.
Inside the source file I have several tabs (also using links) all referencing one "master" tab for data entry. These values are propagated from the master tab to other tabs in the source file. I am able to sort on data in the master tab (this is where data is entered to drive other tab values) but can not sort data in the tabs where the values are linked to.
My question; Is it possible to search on linked data? And if so, how is it done?
I would appreciate any help. I am new at this whole "linking" thing.
Thanks in advance!!!
Inside the source file I have several tabs (also using links) all referencing one "master" tab for data entry. These values are propagated from the master tab to other tabs in the source file. I am able to sort on data in the master tab (this is where data is entered to drive other tab values) but can not sort data in the tabs where the values are linked to.
My question; Is it possible to search on linked data? And if so, how is it done?
I would appreciate any help. I am new at this whole "linking" thing.
Thanks in advance!!!