Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
After some automatic downloads from Microsoft I note that my Excel 2003
Pivot Tables again work and can be refreshed with new data in the worksheets (I was not able to do this after I downloaded something from Microsoft's site). Now, the problem I have is that cannot insert a new calculated field in any of my pivot tables. In the past to insert a new calculated field I did the following: 1) in the Insert Calculated Field Box, I selected the required fields from the list of fields (Fields Box), hit the Inset Button, and inserted operands i.e. divide, multiply, etc; 2) when the formula was completed, I'd hit the OK button. The new calculated column would automatically appear in the pivot table. Now, I create a formula, hit the OK button and nothing happens! I thought it might have something to do with the file size exceeding a certain size limitation, so I removed one file from the workbook, but I still cannot create new calculated fields. I would really appreciate any advice anyone can offer. Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculated field problem in a Pivot table | Excel Discussion (Misc queries) | |||
remove a calculated field from a pivot table in Excel 2003 | Excel Discussion (Misc queries) | |||
HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003 | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Field Problem | Excel Discussion (Misc queries) | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) |