LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grouping error in Excel 2003/2007 Pivot table connect to offline c KT[_2_] Excel Worksheet Functions 0 June 4th 08 04:41 AM
Excel 2007 pivot chart/table copying vs Excel 2003 xpdnt1 Charts and Charting in Excel 0 May 6th 08 07:51 PM
Excel 2007 pivot table formats that work with 2003 Steven Excel Discussion (Misc queries) 1 March 22nd 08 12:44 AM
Pivot table from 2003 to 2007 PivotMan Excel Discussion (Misc queries) 5 February 7th 08 05:12 PM
Excel 2003 view formula within pivot table jpjejmcc Excel Worksheet Functions 3 July 28th 05 06:08 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"