Using 2 workbooks

[Artie060]

I have a work book for my clients and tracking information but it is slow due to some formulas. I have a "past due" sheet that I would like to move to a new workbook but maintain the link to the old original work book. I have tried all the different iterations of cut and past but keep getting a REF error. I can't seem to find where the error is. When I do a copy and past the Link to the original sheet file name populates at the BOLD area but nowhere else.

here is the formula...

=IF(ROWS($A$4:A4)<=$B$2,INDEX(INDIRECT(A$3),SMALL(IF(PAST_DUE_2=$A$2,ROW(PAST_DUE_2)-ROW(Main!$Y$2)+1),ROWS($A$4:A4))),"")

Your thoughts...

Artie

 

[Drrellik]

Just a guess here try to right click on the sheet name Main! and select Move / Copy and create a copy in a new sheet first

then modify the bold Main(2) back to Main! and see if it still works properly, then move on to right click copy, into a new workbook and modify ROW(main! to ROW([Book1]main!... where book1 is the first workbook