Refreshing Data Connection changing forumlas issue??

[Chrisfav89]

Hello,

I've recently run into an issue where the formulas in my summary tab are being changed when I refresh my data connection. Has anyone seen this before? Or know how to trouble shoot?

To give some context there are two formulas below. When I refresh the data connection the $R:$R changes to $S:$S for every formula on my summary sheet. No other cell references change.

Someone please help so I don't have to manually correct each one for the 13 different files I have this data connection applied to!



=IFERROR(INDEX('CM Data'!$R:$R,MATCH(Var!$C20&'Template Info'!$H$1,'CM Data'!$D:$D,0)),0)

=SUMIF('CM Data'!E:E,'Template Info'!H1,'CM Data'!R:R)


Thanks,
Chris

 

[Chrisfav89]

Can anyone out there help with Data Connections? I'm still having the same issue as above and its driving me insane!