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.

Hi Jiang
I havn't a chinese Ver of excel but i think your problem is your calender:
1- goto control pannel and open Regional and language option
2- click the customize
3- in date tab change your calender to Georgian English

"jiang" wrote:

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.