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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 not showing imported numbers in pivot table
Solution: The problem was in the MS Access 2007 .mdb data type.
When I created my Make Table query, the data type defaulted to text rather than the number data type of the Access 2003 source .mdb from which I pulled the data. That appears to be a compatability bug between Access 2007 and Access 2003 that it doesn't hold the data types. The workaround is to first create the table and data types in Access 2007 and then use Apend qureries. Cheers, Garth "Garth" wrote: 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 |
Reply |
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) |