Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Data
Hi,
I need to create a pivot table using a long list of data which unfortunately spills over 65536 rows, therefore I have had to create the data source on two worksheets. Is someone able to tell me whether I can create a pivot table using data on two worksheets to combine into one pivot table? I have tried when selecting the source range to try and select Sheet 1 info and then select data from Sheet 2 also but it won't let me? Any ideas? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |