C
chumpy
I have setup a workbook so that I can have a user compile a simple report. I
have 3 worksheets each of these are SAP Business Warehouse queries. The third
sheet also contains rather simple formulas at the right of the data (ie
lookups referring to the other two sheets). These formulas appear to be fine
and appear without error. I have a 4th pivot table sheet that places certain
colums in a specific order.
The issue I have is when the other user refreshes the pivot table, 3 columns
show "#NAME?", however when I refresh the pivot from the same file the
refresh works fine....i'm stumped!
I have removed the issue of versions because I have refreshed the reports in
both excel 2002 and 2007 and I get the same results. The user only users
excel 2002
Appreciate any assisance!
chumpy
have 3 worksheets each of these are SAP Business Warehouse queries. The third
sheet also contains rather simple formulas at the right of the data (ie
lookups referring to the other two sheets). These formulas appear to be fine
and appear without error. I have a 4th pivot table sheet that places certain
colums in a specific order.
The issue I have is when the other user refreshes the pivot table, 3 columns
show "#NAME?", however when I refresh the pivot from the same file the
refresh works fine....i'm stumped!
I have removed the issue of versions because I have refreshed the reports in
both excel 2002 and 2007 and I get the same results. The user only users
excel 2002
Appreciate any assisance!
chumpy