Hi, i have quite a large detailed spreadsheet with formulas in each cell from 1 to 600 G to GC
Column A is blank, and Columns B,C,D,E,F are populated by a data query bringing in data from a MS Access query.
However everytime i run the query update in Excel, it imports the data fine into Columns B-F, however it then messes up some of the formulas.
It is usually just 1 or to rows, but it changes the formula cell references.
i.e. in column BM changed formula from =SUMIF(B$4:B235,B236,G$4:G235)/COUNTIF(B$4:B235,B236)
=SUMIF(B$4:B341,B236,G$4:G235)/COUNTIF(B$4:B341,B236)
so changes the row numbers, it does this across the entire row, however rows above and below it remain unaltered.
Can somebody please help with this, as it is causing me a huge headache.
Many thanks
Richard
Column A is blank, and Columns B,C,D,E,F are populated by a data query bringing in data from a MS Access query.
However everytime i run the query update in Excel, it imports the data fine into Columns B-F, however it then messes up some of the formulas.
It is usually just 1 or to rows, but it changes the formula cell references.
i.e. in column BM changed formula from =SUMIF(B$4:B235,B236,G$4:G235)/COUNTIF(B$4:B235,B236)
=SUMIF(B$4:B341,B236,G$4:G235)/COUNTIF(B$4:B341,B236)
so changes the row numbers, it does this across the entire row, however rows above and below it remain unaltered.
Can somebody please help with this, as it is causing me a huge headache.
Many thanks
Richard
