Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Range ("Database")
If you build a pivot table in Excel 97-2000 when a cell inside the database
you want to use is selected, the pivot wizard will assume that you want to use that whole database for your pivot table (without you having to specify the range) I'm now using 2003 and it won't do it anymore. Is there something wrong with my settings? Many thanks Helen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) |