| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refreshing Data within a pivot table
I have downloaded a sales order file approx. 14,000 lines of data and I am
using pivot table to review qtrly sales of different parts. The pivot table has returned data as expected but there is a qty against a blank field that should contain the part number. Within the raw data the part field for repairs was blank (Explaining my problem) so I have gone back and and typed repair into the data source and then hit the refresh data button on the pivot table. The update is still not pulling in the correct totals - any ideas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| VC Problem refreshing pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Threaded Mode
