View original (French)

Error "The pivot table field name is not valid"

anastasiaS974 Posted messages 3 Status Membre -  
anastasiaS974 Posted messages 3 Status Membre -
Hello everyone,

Every month I update a tracking table that is linked to pivot tables, but this month I am unable to update all my pivot tables.
Indeed, when I click on 'Refresh All', the error message (see title) appears.
I have tried all the tips found on the forums (duplicate titles, empty columns or rows, formulas in headers, merged cells, ...) but nothing works.

Here are the characteristics of my table (which I cannot share due to confidentiality):

- Row 1: TITLE with merged cells
- Row 2: SUBTITLE with merged cells
- The other rows contain individual data
- Excel 2013
- Several sheets with different pivot tables

Can you help me?
It would save me a lot of time since, to date, I have to refresh my pivot tables one by one and I have more than 60 ...

Thank you in advance!!!

Sincerely

2 réponses

Réponse 1 / 2
danielc0 Posted messages 2134 Registration date   Status Membre Last intervention   270
 
Hello,

Could you perhaps post the list of field names?

Best regards.

Daniel
0
anastasiaS974 Posted messages 3 Status Membre
 
- ID NUMBER
- Comparative extract ID number
- Comparative extract Yes/No
- Last name
- First name
- N+1
- Comparative extract N+1
- Comparative extract N+1 Yes/No
- BU
- Site
- MI
- Start date
- Date of first professional interview
- Month of employment contract anniversary
- Type of contract
- Type of contract 06.2019
- Comparative type of contract Yes/No
- 2016
- 2017
- 2018
- 2019
- Planned EAs
- Planned EPs
- Received EAs
- Received EPs
- EPs carried out since 2016
- Planned EPs in 2020
- EPs carried out 2016-2020
- Seniority in days
- Seniority in years
- 3P in the last 6 years 1=0 2=N

Thank you.
0