| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - multiple sources
I have a data source with ~75,000 records, which needs to be the source for a series of pivot table reports. Is there a way, that I can break the 75k records into 2 worksheet and have the tables on both sheets be the source for my pivot tables? I've see a very simplistic way to do this, within the help file, but it doesn't provide the ability to see all of the data elements. Also, these reports are distributed so linking to directly to an Access table doesn't seem possible. Any help would be greatly appreciated. -- BC... ------------------------------------------------------------------------ BC...'s Profile: http://www.excelforum.com/member.php...o&userid=34318 View this thread: http://www.excelforum.com/showthread...hreadid=540825 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table - multiple sources
Can't you use the pivot table on your data source, or you could put it into
Access and use the pivot table on the Access table? -- Regards, Peo Sjoblom http://nwexcelsolutions.com "BC..." wrote in message ... I have a data source with ~75,000 records, which needs to be the source for a series of pivot table reports. Is there a way, that I can break the 75k records into 2 worksheet and have the tables on both sheets be the source for my pivot tables? I've see a very simplistic way to do this, within the help file, but it doesn't provide the ability to see all of the data elements. Also, these reports are distributed so linking to directly to an Access table doesn't seem possible. Any help would be greatly appreciated. -- BC... ------------------------------------------------------------------------ BC...'s Profile: http://www.excelforum.com/member.php...o&userid=34318 View this thread: http://www.excelforum.com/showthread...hreadid=540825 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table - multiple sources
http://www.excelforum.com/showthread.php?t=538191 seems related -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=540825 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table - multiple sources
oops .. pls ignore .. will still hit the 64k limit. Can you export to a .CSV file and run the pivot table directly against that as external data? -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=540825 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| How to choose multiple itmes from a Pivot Table Page drop down men | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
