Linked Pivot table references not read the same by all user

brevika

New Member
Joined
Oct 22, 2006
Messages
5
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

brevika

New Member
Joined
Oct 22, 2006
Messages
5
Follow-up by author

By the way, I run the reporting on Microsoft Excel 2002 SP3.

I have also run it on Excel 2003 SP2.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top