The error message #NAME? remains on the Pivot Table of my report even after clicking "Enable Editing" in Excel

Symptoms

  • The Pivot Table does not show values in the Database Preview of the report
  • When downloaded, "Enable Editing" does not enable the information on the pivot table

Applies To

  • Reports
  • Excel Settings
  • Formulas
  • Custom reports

Cause

Your Microsoft Office is out of date 

Resolution

Update your Microsoft Products with the latest update

Additional Notes

Access this link for assistance from Microsoft on how to update your software

If you are getting the error #NAME? on the database preview, Click Here