We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Why formulas are not updated when inserting rows?

Platform: WinForms |
Control: XlsIO


This issue happens not because of inserting the rows. if the sheet has the range that refers to a single cell [For eg:SUM(B2:B2)] then formulas cannot be updated. This is the default behavior of MS Excel. This can be solved by changing range reference in your template file as follows:

  • Insert a new row.
  • Then Change the formula. Say, "SUM(B2:B3)" instead of using "SUM(B2:B2)"
  • Also you can delete the unwanted rows after updating the formulas.

The below link has the sample with the changed template file:


2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile