Excel 97
 

Does anyone know if it is possible to select multiple cells from 2 different
Pivot Tables? I have 2 pivot tables, each with a Total and would like to
select the Totals from the 2 Pivot Tables. I know this can be done with
Office 2003 and when selected, the SUM of the cells appears in the bottom
right of the spreadsheet.

I don't have xl97 to test this on, but if your pivottables are on one
worksheet, then select the first range and ctrl-click to select the second
range.

If you don't see the sum, try rightclicking on the statusbar near those embossed
boxes and select Sum.

Tools|Options|View Tab|Make sure Status bar is checked.

jjonesa wrote:

Does anyone know if it is possible to select multiple cells from 2 different
Pivot Tables? I have 2 pivot tables, each with a Total and would like to
select the Totals from the 2 Pivot Tables. I know this can be done with
Office 2003 and when selected, the SUM of the cells appears in the bottom
right of the spreadsheet.

--

Dave Peterson