Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row insert fails to update Sum formula
I am using Office 2003.
A new row is inserted in a sheet programmatically. When this is done the sum formulas (that have also been entered programmatically) do not update to include the row inserted, unless a value is entered on the newly inserted row. NOTE: This only occurs when the row inserted causes the row containing the sum formulas to shift down. For example, row 14 contains sum formulas. My code inserts a row on row 14. The sum formula, shifted to row 15, now excludes row 14. If a value is entered into row 14, then the sum formula in that column sometimes updates to include row 14, but sometimes it doesn't update (don't know why). The sheet has split windows on and some cells are locked, but my function unprotects the sheet while inserting the row. How can I correct this behaviour programmatically so that the formulas will include all rows to begin with [e.g. =SUM(A4:A18)] ? Thanks in advance for your assistance. I hope my description is understandable... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert objects in .xlsx fails with message "cannot insert object" | Excel Discussion (Misc queries) | |||
SECURITY UPDATE FAILS TO INSTALL | Excel Discussion (Misc queries) | |||
MSN Stock Quotes Addin fails to update | Excel Worksheet Functions | |||
Excel formula fails to update | Excel Discussion (Misc queries) | |||
Update fails. Source not found. | Links and Linking in Excel |