Excel 2007 table ranges do not work in multilingual configurations. The
solution I am developing involves external data, however, I managed to
isolate the problem so that it can be reproduced in a few easy steps:

1- Create an empty workbook.
2- Compose a simple table, for example monthly sales.
[A1]: Month, [B1]: Sales
[A2]: Jan, [B2]: 10
[A3]: Feb, [B3]: 10
3- Select the whole table, click "format as a table".
4- Insert a pivot table to the same sheet, select the table you just created
as the data source, the reference should be Table1[#All].
5- Save the workbook, close Excel.
6- Change the UI to another language, reopen the workbook, try to refresh
the pivot table, you will get an error message.

The reason is that Table1[#All] works only on English systems. The keyword
#All is different for each language.

If you write a formula like SUM(A1:A9) on an English system, it
automatically becomes SOMME(A1:A9) on a French system, neither the developer
nor the user has anything special to do. One would expect the same behavior
for the keyword #All, however, that's not the case, it fails.

Am I missing something, or is it a bug?

Sincerely.
Elyo Ravuna