Hi,
I have assembled a model reading external database data into a pivottable.
A reporting tool reads links in the pivot tables.
In my setup such a link would read something like:
=+GETPIVOTDATA("Sum av TOT_OMSETNING";$A$3;"BUTIKK_AVD_ID";1;"BUTIKK_AVD_NAVN";"KJØTT")
Whereas for some other users, the same linking provides a reference like:
=C5
The model works fine for some, but fails miserably for other users. I hope this is a tickoff box somewhere in Excel, or perhaps something to do with using different Excel versions.
Please help, delivery time is upon me!!
Thanks for the feedback.
I have assembled a model reading external database data into a pivottable.
A reporting tool reads links in the pivot tables.
In my setup such a link would read something like:
=+GETPIVOTDATA("Sum av TOT_OMSETNING";$A$3;"BUTIKK_AVD_ID";1;"BUTIKK_AVD_NAVN";"KJØTT")
Whereas for some other users, the same linking provides a reference like:
=C5
The model works fine for some, but fails miserably for other users. I hope this is a tickoff box somewhere in Excel, or perhaps something to do with using different Excel versions.
Please help, delivery time is upon me!!
Thanks for the feedback.