I took over a Excel project that used a data provider. I'm not using that anymore and instead I'm just importing the data via macros. All has gone well but rows 2-77 are some how linked? If I change a formula in row 2 column 10 then all rows from 2 - 77 have that same formula. All rows after are fine. No matter what row I change in the 2-77 range it auto populates the others in that range.
So I figured first it must be a macro, well its not. At least I can't find it. Then I figured it was the data provider so I removed all of that that with no luck. I did find the filter->advanced to have that exact range in it but changing that did help either. It only seem to be the formulas that do this, not values.
What else could be doing this?
Bookmarks