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


  • 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


Your Microsoft Office is out of date 


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