| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 not showing imported numbers in pivot table
I am importing an MS Access 2007 .mdb table into Excel 2007 as a pivot table.
When I include bookings in the Values section and change display type from count to sum, I see 0.00. One issue I discovered is that Excel is importing numbers as text, which I think is a bug. When I use error checking to correct, by converting "number stored as text" to number, I am still unable to see bookings values in the pivot. Any idea of what's going on and how to correct? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| pivot table showing row field with no value | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Pivot Table not showing subtotals | Excel Discussion (Misc queries) | |||
Threaded Mode
