Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Pivot Table errors
Please assist in identifying the reasons why the pivot table function within
Excel does not operate correctly. Several pieces of data are missing when summed, but when you double click on the cell with an empty value it correctly returns the spreadsheet with found data |
#2
|
|||
|
|||
Excel Pivot Table errors
Some of the numbers in the source data may be text, instead of numbers.
To convert them to real numbers, you can use one of the techniques shown he http://www.contextures.com/xlDataEntry03.html wrote: Please assist in identifying the reasons why the pivot table function within Excel does not operate correctly. Several pieces of data are missing when summed, but when you double click on the cell with an empty value it correctly returns the spreadsheet with found data -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you unlock a pivot table on a protected excel sheet? | Excel Worksheet Functions | |||
Excel Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |