I have an excel spreadsheet (both 2003 and 2007) that pull data from a SQL server table. The table is basically stores corporate metric information for each month. The problem I am having is that I have other cells that add up quarterly information and the formulas are changing when new months are entered into the SQL table and pulled into the excel spreadsheet, even though I have $ signs in the formula.
For example, my SQL table has 6 rows in it right now, Jan through June. I have a cell with a formula that adds up the Jan - March, Apr - June, Jul - Sept, and Oct - Dec. My cell that adds up Apr - June is =SUM(E$13:E$15). If I throw in a July row in my SQL table then refresh the data, my cell that adds up Apr - June changes to =SUM(E$13:E$16). The cells that add up my 3rd and 4th quarter numbers bump down a row.
I don't want my cells that look at my external data to change when new external data is coming in. Is there a setting that I'm missing? Thank you in advance.