5 pts.
 Excel 2007 data – sorting source workbook
I want to create a link to data in a second workbook. My problem is when the source workbook is sorted, the links are misaligned. I don't think absolute/relative references are the issue. How do I create a link such that no matter where external reference in the source workbook workbook moves to, the link holds true?

Software/Hardware used:
ASKED: September 8, 2008  4:29 PM
UPDATED: September 8, 2008  4:35 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _