Home > IT Answers > Database > Pivot Table Error Field Message
Buckeyes08
10 pts.
 Pivot Table Error Field Message
Access Database, Microsoft Access, Pivot tables
I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid. To create a Pivot Table report, you must use data that is organized as a list with labled columns. If you are changing the name of a Pivot Table field, you must type a new name for the field." I do not understand why I am receiving this message. I lost the connection between my access database and the spreadsheet so I had to attempt to try and re-connect to it. I don't know if maybe during the re-connection period to the access database whether the pivot table connection was lost. I just keep receiving the error message and I have not altered the names in the table. Please Help!

Software/Hardware used:
ASKED: September 5, 2008  3:17 PM
UPDATED: June 21, 2011  1:32 PM
RELATED QUESTIONS
Answer Wiki:
Obviously your initial connection is lost. Not knowing which versions of Excel & Access you are using – here are my comments on Access 2007 & Excel 2007. You may try to re-connect the fields from access database (Of course this assumes you know the table name or the query name!). Click on the Excel cell that you want the data from access-db, click Data, then From Access (top left hand side), select the database, then select the table (or the query); on Import data screen – select Pivot Table Report & then Ok. Hopefully this will populate the needed data. You may experiment with the property field & make it “refresh data when opening the file” or “Remove data from external data source before saving the workbook”. Good luck!
Last Wiki Answer Submitted:  September 8, 2008  4:15 pm  by  SbElectric   2,510 pts.
All Answer Wiki Contributors:  SbElectric   2,510 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am having a similar experience with Excel 2007, where on editing a connection data source, it lost the comma delimiter setting. Thus the import only filled column A. When I added the comma delimiter setting back in and re-imported, Excel inserted columns to the right… Still workign on this
Microsoft say you get the above message you quote when the Pivot Table ‘s data source’s first row of cells contians blanks.

Antandcharmi
 10 pts.