Sumif formula is changing my link to a table after I close the workbook

[emoen]

I'm trying to write a sumif formula that is linking to a table and it keeps changing the formula once I save/close and then reopen the file. I highlight the column "Region" in my table (which is located in a different workbook) and it populates correctly in the formula and then when I reopen the file it changes the "Region" to the cell #'s (ex B4:B27142). I don't want it to be the cell numbers in case my table changes (either gets shorter/longer or the columns change places).

Here is the right formula
=SUMIF('SERVICE COMP BREAKDOWN.xlsx'!<wbr>ServiceCompBreakdown[Region],I<wbr>NPUT!$B$4,'SERVICE COMP BREAKDOWN.xlsx'!<wbr>ServiceCompBreakdown[DSCAMOUNT<wbr>$])

Here is what it changes to
=SUMIF('[SERVICE COMP BREAKDOWN.xlsx]OUTPUT'!$B$4:$<wbr>B$27142,INPUT!$B$4,'[SERVICE COMP BREAKDOWN.xlsx]OUTPUT'!$I$4:$<wbr>I$27142)

Do you have any idea why this is happening and how to fix it? Maybe it's because I'm using Excel 2010?

 

[JoeMo]

Have you tried closing your workbook before the source workbook (the workbook containing the table) is closed and ensuring that the source workbook is open prior to opening your workbook?

 

[emoen]

Yes I have done that and it has the same results