software

I am setting up a workbook that has cell formulas linked to data in 2 other
workbooks. I want to know if there is a way that I can sort the data in the
2 source workbooks while maintaining the correct linked cell formulas in the
destination workbook? (when I sort the data in the source workbooks it does
not update the new cell formulas in the destination workbook and therefore
pulls the wrong data)

Did you try making your formulas absolute?quot;jfb191quot; wrote:

gt; I am setting up a workbook that has cell formulas linked to data in 2 other
gt; workbooks. I want to know if there is a way that I can sort the data in the
gt; 2 source workbooks while maintaining the correct linked cell formulas in the
gt; destination workbook? (when I sort the data in the source workbooks it does
gt; not update the new cell formulas in the destination workbook and therefore
gt; pulls the wrong data)

No I didn't. How do I go about doing that? Thanks for your response!

quot;Difficult1quot; wrote:

gt; Did you try making your formulas absolute?
gt;
gt;
gt; quot;jfb191quot; wrote:
gt;
gt; gt; I am setting up a workbook that has cell formulas linked to data in 2 other
gt; gt; workbooks. I want to know if there is a way that I can sort the data in the
gt; gt; 2 source workbooks while maintaining the correct linked cell formulas in the
gt; gt; destination workbook? (when I sort the data in the source workbooks it does
gt; gt; not update the new cell formulas in the destination workbook and therefore
gt; gt; pulls the wrong data)