Dear Jialiang,

This workaround works perfectly. Thanks a lot!

Sincerely,
Elyo Ravuna

"Jialiang Ge [MSFT]" wrote:

Hello Elyo,

Thank you for your patience. According to the response of Excel product
team, "=Table1" should be the same as "=Table1[#All]". Likewise to use an
entire column just =Table1[Column1] should be sufficient. This avoids using
keyword [#All] which should solve the problem. Here is my test steps:

1. Create an empty workbook.
2. Compose a simple table:
[A1]: Month, [B1]: Sales
[A2]: Jan, [B2]: 10
[A3]: Feb, [B3]: 10
3. Select the whole table, and format the table.
4. Insert a pivot table to the same sheet, select the table we just
created, the reference should be Table1[#All].
5. *change the reference as Table1*
6. Save the workbook, close Excel
7. Change the UI to French, reopen the workbook and refresh the pivot table.

Please try it on your side and let me know if it works. If you need further
assistance, feel free to let me know. I will be more than happy to be of
assistance.

Have a great day!

Sincerely,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.