Hi,
I'm pulling in data from a website and everything worked great.
However, the next week when the table headers/data has been updated (it's based on football matches from a betting company - so the fixtures update accordingly) - I click refresh, and all formulas on that tab N/A. It doesn't matter if I move those formulas 50 cells to the right, 200 cells underneath or even cut and paste to a new tab. For clarification the formulas are looking at the data which has been refreshed.
Has anyone experienced this issue and have a resolution? It's worth noting that I have the same number of columns week on week.
If there is a fix I'd be be very grateful.
Regards
Ryan
I'm pulling in data from a website and everything worked great.
However, the next week when the table headers/data has been updated (it's based on football matches from a betting company - so the fixtures update accordingly) - I click refresh, and all formulas on that tab N/A. It doesn't matter if I move those formulas 50 cells to the right, 200 cells underneath or even cut and paste to a new tab. For clarification the formulas are looking at the data which has been refreshed.
Has anyone experienced this issue and have a resolution? It's worth noting that I have the same number of columns week on week.
If there is a fix I'd be be very grateful.
Regards
Ryan
