Successful restore of Sharepoint 2010 list results in '#DIV/0!' being displayed in calculated fields.

Article:TECH213812  |  Created: 2014-01-09  |  Updated: 2014-01-09  |  Article URL
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


After the successful restore of a Sharepoint 2010 list containing one or more calculated fields the list may be displayed with a calculation error - #DIV/0! instead of the calculated value. 


There are no errors in the restore job, it completes successfully.



 - From the restored list view in Sharepoint, go to the List Tools and select 'List Settings'.

 - In the 'Columns' section click on the calculated field showing the errors.

 - Confirm that the formula displayed is correct and click 'OK'

 - Return to the list view and note that the calculated field errors are now resolved with the correct calculated values are shown.

Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned in this article. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns.  For information on how to contact Symantec Sales, please see Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.


Supplemental Materials

DescriptionSPSV4 - Successful restore of list with calculated fields shows '#DIV/0!' in those fields after restore.

Article URL

Terms of use for this information are found in Legal Notices