Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Across Multiple Sheets of Data
I can't seem to run a pivot table across multiple sheets of data. All of my
sheets are formatted the same way. I've gone ahead and started the pivot table and then when I select the data, I've tried to click on the sheets one by one while holding down the shift button. I get the error message, Data Source Reference is Not Valid. So then I go through and manually select the data range for each sheet, but it seems that I can't build the list. When I run the table it just includes the data from the last sheet that I selecte. Please Help! -- Nick MMG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single Pivot Table 4 Multiple Sheets? | Excel Discussion (Misc queries) | |||
Pivot table from multiple sheets - odd result | Excel Discussion (Misc queries) | |||
Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table from multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table--How can I create from multiple sheets? | New Users to Excel |