This is driving me absolutely NUTS! Before I throw my computer out the window, I figured you guys might be able to help me out. I've got a spreadsheet with 4 columns of numbers: met, missed, grand total, and percent met. To get the percent, I've got a formula in there that just says =B2/D2 where B2 is the met column and D2 is the total column. You copy it down the column for all the rows you need a percentage on, and whamm-o, it changes to =B3/D3, =B4/D4, etc. I've been doing it for ages & its always worked just fine.

Today I go to do the same thing, and it won't work! It copies the formulas correctly, changing row by row the way its supposed to...but the value it displays is the value from the first cell. If I double-click in each cell after pasting, it updates with the correct value for that row...but I've got over 25,000 rows this month and there is NO WAY I'm going to manually sit here and double click 25,000 cells just to get a formula to update.

Does anybody know why its doing this and how I can get it to go back to normal before I pull whats left of my hair out?