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!
September 5, 2008 3:17 PM
June 21, 2011 1:32 PM