View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheri D. Cheri D. is offline
external usenet poster
 
Posts: 1
Default Automatically update formula (sum) when inserting row

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?