ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2003 Pivot Table Problem - Can No Longer Create Calculated Field (https://www.excelbanter.com/excel-worksheet-functions/253189-excel-2003-pivot-table-problem-can-no-longer-create-calculated-field.html)

Peter Van Eerde

Excel 2003 Pivot Table Problem - Can No Longer Create Calculated Field
 
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




All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com