sorry for the confusion. I tried to find it on the help and everything. also,
i asked some people that have more experience on excel than me.
I have this huge excel file that always been updated by different
department. I would like to link that file to my own file, since my
requirements are different than them. My own file consists of 2 data (on
separate colums) that I took from the base file. In order for me to keep
updating my own data, I linked them with pivot table. So, I can refresh it
to reflect new data.
After the pivot table, I created my own independent calculation. The
problem is everytime I update my pivot table, it won't update the calculation.
Example: (first 2 columns as pivot table)
Part numbers Quantity/product product produce total(col 2 x3)
123 3 2
6
234 2 1
2
254 1 3
3
let's say there is a new number = 150, it will go to row 2 when you refresh
it.
I would like when there is a new number, column 3 and 4, should make the row
empty.
maybe i should use different method or something. i thought excel can do this.
thank you for all your advice. hopefully this explanation helps. i
appreciate it if you can help.
--GI

"Lonnie M." wrote:

GI,
I am not sure if I understand what you are trying to do, but two things
that you may want to search out in both the help file and this usenet:
1. Create your own formula in a PivotTable
2. Extend formats and formulas to additional rows

HTH, Lonnie