Edit Formula in Pivot Table for 2003 and 2007-how?
I don't know if I should finish the week right now because I'm pathetic at
trying to solve this problem.
Here goes:
1) I want to edit a formula that I have created in my Pivot Table and I
can't see where that is possible.
2) I have my list and I have created a Pivot Table.
3) I have a column with my expenses.
4) I created a formula which says "=expenses*10%"
5) It works fine.
6) I want to be able to edit the formula to 20% but I can't see where I can
edit the formula.
7) It seems like my only option os to delete it and create one with 20%.
8) I have tried this with Excel 2003 and 2007 and both are the same.
Is it possible to edit the existing formula?
If anyone has the answer, I would be very appreciative. If not, I'm calling
it a week :)
Thanks for any assistance in advance!
Jugglertwo
|