| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I generally get as default field setting the 'Count' value. Is there a way to format the spreadsheet to make Excel recognize the data as all numbers so it defaults to the "Sum" function as opposed to "text"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table defaults | Excel Discussion (Misc queries) | |||
| Pivot table filed defaults | Excel Worksheet Functions | |||
| pivot table defaults to pivot chart | Charts and Charting in Excel | |||
| function defaults change in Pivot Table..why? | Excel Discussion (Misc queries) | |||
| Pivot table, summary function defaults | Excel Discussion (Misc queries) | |||
Threaded Mode
