LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arreferee
 
Posts: n/a
Default Formula doesn't update when rows are inserted

I have a formula that is simply adding cells E8:E184. When I insert rows
(begining with E185) and populate those rows with data, the formula doesn't
pick these up. In all of my other spreadsheets, the formula automatically
updates with the inserted rows, but this one doesn't want to do this. Anyone
have any ideas?

Thanks,
arreferee
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fix a formula, so when a row is inserted it doesn't cha Paul Cahoon Excel Discussion (Misc queries) 4 December 9th 08 09:50 PM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
apply formula to other rows ... berti Excel Discussion (Misc queries) 1 December 15th 05 08:30 AM
If formula result is false, how do I auto-delete that rows? jbrenner51 Excel Worksheet Functions 1 November 16th 05 05:24 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"