ChesterKaup
New Member
- Joined
- Aug 19, 2010
- Messages
- 36
I have a spreadsheet that has a query attached to refresh data from a ms access table. Each month it brings in one more tow of data from access. This part works fine. There are formulas in the columns next to the data that is imported. Here is what the formula in the row next to last row of imported data before an import.
=IF($A468>=$N$1,D468*$C468/1+N467,0) and the next row below =IF($A469>=$N$1,D469*$C469/1+N468,0)
After running the data refresh that brings in one more row of data the formulas look like this. The first one changed to
=IF($A469>=$N$1,D469*$C469/1+N467,0)
The second one changed to =IF($A470>=$N$1,D470*$C470/1+N468,0)
I have the tried checking and unchecking the advanced option Extend data range formats and formulas with no change in the results.
I am at a loss of what to do to keep the formulas from changing. Thanks.
=IF($A468>=$N$1,D468*$C468/1+N467,0) and the next row below =IF($A469>=$N$1,D469*$C469/1+N468,0)
After running the data refresh that brings in one more row of data the formulas look like this. The first one changed to
=IF($A469>=$N$1,D469*$C469/1+N467,0)
The second one changed to =IF($A470>=$N$1,D470*$C470/1+N468,0)
I have the tried checking and unchecking the advanced option Extend data range formats and formulas with no change in the results.
I am at a loss of what to do to keep the formulas from changing. Thanks.
