Hi,

I made a pivot table from a table, include a date column and another column
with year() function to get year from input date. In my english Excel, pivot
table shows correctly when I made row from year column.

But when my colleague from China open my pivot table, #value is shown in
pivot table where year column is. The only difference is my colleague use
Chinese Version EXCEL, i'm use English version EXCEL. is this the reason? I
doubt.

thanks if any suggestion.