Selecting data in a PivotTable report

D

Duncanl

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have created a pivotTable report and now want to select the data in the table to create some graphs of the data. When I try to select data across columns the selection highlights only the column under my curser and will not select multiple columns? Any thoughts?
 
P

Pat McMillan

This is a bug we're aware of. We're currently working on a fix. As a
workaround, please click in the Name Box on the Formula Bar and type in the
range you want to select (for example, A1:C10), then press <return>. If you
expect to be selecting the same data range repeatedly, you could then click
in the name box again (while the intended range is selected) and enter any
name for the range, such as "chartdatarange", and press <return> again. That
way you will be able to easily select the range the next time you need to
select it.

Thanks,

Pat
 
Top