Link changes data range

[erutherford]

Workbook A is linked to another workbook (call it B). Workbook B data changes daily. Workbook A reads and formats that data for numerous reports. An updated Workbook B file is available. Workbook A runs a couple of simple macros to format the worksheet. The formulas in workbook A change to read Workbook B before and not after formatting. Should I break the link and add code to do it?
Here is sample of the code

=COUNTIFS([regdwnld.xlsx]export!D:D,"Street", [regdwnld.xlsx]export!H:H,"Open")

It should read I:Iexport!, but it gets changed to D:D! - H:H changes from I:I

 

[erutherford]

After some testing, the problem occurs when the macro that reorders the columns runs. This causes the formula to look at the wrong columns. Don't rearrange the columns, formulas are happy. For now I can live with the order of the columns as they are and continue on with the project.