Hi all,
I run a weekly report for 4 account managers. Part of the report includes a table of sales results. These results are from a pivot table - in the same report, on a hidden tab, using the GetPivotData formula. In the formula I have included an 'iferror' statement to return a zero in the event of an error.
The problem is that two of the users (3 including myself) can use/view the report fine, the table updates according to the pivot table contents. For the other two users however, the table is all zero's (regardless of which account managers results are viewed).
I have checked the calculation settings and they are set to automatic. We are all using the same operating system and version of excel.
Is there something obvious I might be missing? I upload the report weekly to our Sharepoint site - we are all accessing the same report, so why is the formula returning the pivot results for some, but zero's for others?
Any assistance would be most appreciated!
I run a weekly report for 4 account managers. Part of the report includes a table of sales results. These results are from a pivot table - in the same report, on a hidden tab, using the GetPivotData formula. In the formula I have included an 'iferror' statement to return a zero in the event of an error.
The problem is that two of the users (3 including myself) can use/view the report fine, the table updates according to the pivot table contents. For the other two users however, the table is all zero's (regardless of which account managers results are viewed).
I have checked the calculation settings and they are set to automatic. We are all using the same operating system and version of excel.
Is there something obvious I might be missing? I upload the report weekly to our Sharepoint site - we are all accessing the same report, so why is the formula returning the pivot results for some, but zero's for others?
Any assistance would be most appreciated!
