You can prevent the GetPivotData formulas from appearing. There are
instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html


Access4Afghan wrote:
Dear Nick:
Thanks for the respond. I also believe we should use Access if we have more
records. But the issue of the formula is not supported in the current version
of ATLAS. For Example. If you have the Stock of Shoes and Icecream and you
have detail of how much/many you had in each location and how much is sold.
You make a formula of Balance=InStock-SoldOut. Now you didn't have any shoes
in USA, UK and UAE, but had it in Germany France and Russia. Because you
created a formula, all locations will be listed for both products. Now, in
earlier versions, you could make a formula in the column next to the pivot
table and could deduct SoldOuts from InStocks, but now, it uses PivotTable
functions if you use formulas (=). I'm not sure if you understood what I
mean. Otherwise, I can share a pivot table sheet with you. I don't know how
can I attach it here, perhaps email you if you want.
Zubair


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html