sort by name problem

Julien Lopez

Hi

i have reports containing contact list column type and randomly some person are split in two

ex:

i can fix it by refrewshing the report but sometimes not. and it is not always the same person with the issue…

the source sheets are used by 3-4 persons simultaneously.

my report contains 64 source sheet and generate around 1200 lines. is it too big?

any idea what is the problem?

thank you for your help

kowal

hi @Julien Lopez,

it could be that in some of the sheets the Nom employe is contact list alowing only 1 person and in other sheet it can allow multiple contacts that's why in the report it treats those two columns (despite the same name) as two different.

Julien Lopez

Hi @kowal all Nom employe column are for only 1 person. all the sheets are from 1 master so all sheets are identical. i try to remove unecessary columns and references to see if it can help. the problem appears after the addition of a new column in all sheets

thank you for your help