Data Import query from MS Access

SHARPY1

Board Regular
Joined
Oct 1, 2007
Messages
179
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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,126,994
Messages
5,622,053
Members
415,875
Latest member
Tarali

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top