Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems using sort when data has links to other sheets
I have this problem when I do a sort. The sorted data has other sheets
linked to it. When I sort the data, the other sheets seemed locked to the cell rather than the data. For example, if sheet1 contains cell A1 with the formula ='sheet2'!B2 and I do a sort of sheet2, what shows up in A1 is not the original data that was in sheet2, B2. What shows up is the new data in sheet2, B2. I tried putting =sheet2!$B$2 in the A1 cell in sheet1, but it doesn't make any difference, I get exactly the same result. However, if I cut and paste cell B2 in sheet2, then sheet1 A1 follows sheet2B2 anywhere I put it. How can I keep cell A1 pointing to the data in B2 through a sort? Thanks, RobertD -- www.woodpeckings.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I data sort multiple sheets in Excel that are linked with i | Excel Worksheet Functions | |||
Problems saving a worksheet with links | Links and Linking in Excel | |||
Problems saving a worksheet with links | Excel Discussion (Misc queries) | |||
Excel Links Problems | Links and Linking in Excel | |||
Problems with links to another workbook | Excel Worksheet Functions |