Pivot Table Error Field Message

10 pts.
Tags:
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!
ASKED: September 5, 2008  3:17 PM
UPDATED: June 21, 2011  1:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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!

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Antandcharmi
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following