Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
My data is larger than one excel worksheet is capable of so I have split it
by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
You can use multiple ranges in a pivot table, however, you should be aware of
two issues: 1) You may have memory issues if you don't have a large amount of RAM (more than 1 gigabyte, and 2) You will likely run out of columns (max of 255 in pre XL 2007 versions). If you have that much data, a db package like Access is probably a better bet. What exactly are you trying to summarize? "Ellie" wrote: My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
This could be done by producing a pivot table from each worksheet which are
stored in a single worksheet and then combining the outputs by a simple formula. This could be to extract labels and to totalise. Regards. Bill Ridgeway Computer Solutions "Ellie" wrote in message ... My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
Hi Dave
Thanks for the quick reply. I am trying to accumulated sales trends by item by month. I need to show what a customer is paying by month in order to make sure the saleman has charged enough to cover costs. Item prices are individual to the customers and price increases are left up to the salesman. This process is a management check to ensure the salesman is putting through the increases. My pivot table worked fine until we reached 65000 plus records. I was hoping that I could simply name two ranges to one pivot table, but either it can't be done, or I just haven't figured it out yet. "Dave F" wrote: You can use multiple ranges in a pivot table, however, you should be aware of two issues: 1) You may have memory issues if you don't have a large amount of RAM (more than 1 gigabyte, and 2) You will likely run out of columns (max of 255 in pre XL 2007 versions). If you have that much data, a db package like Access is probably a better bet. What exactly are you trying to summarize? "Ellie" wrote: My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
This sounds like something that would be best done in Access.
If you have Access 2003 you can import all the data into a table and run pivot tables off that, with no 65000 row limit. "Ellie" wrote: Hi Dave Thanks for the quick reply. I am trying to accumulated sales trends by item by month. I need to show what a customer is paying by month in order to make sure the saleman has charged enough to cover costs. Item prices are individual to the customers and price increases are left up to the salesman. This process is a management check to ensure the salesman is putting through the increases. My pivot table worked fine until we reached 65000 plus records. I was hoping that I could simply name two ranges to one pivot table, but either it can't be done, or I just haven't figured it out yet. "Dave F" wrote: You can use multiple ranges in a pivot table, however, you should be aware of two issues: 1) You may have memory issues if you don't have a large amount of RAM (more than 1 gigabyte, and 2) You will likely run out of columns (max of 255 in pre XL 2007 versions). If you have that much data, a db package like Access is probably a better bet. What exactly are you trying to summarize? "Ellie" wrote: My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to combine two excel worksheets in one pivot table.
Okay, thanks
"Dave F" wrote: This sounds like something that would be best done in Access. If you have Access 2003 you can import all the data into a table and run pivot tables off that, with no 65000 row limit. "Ellie" wrote: Hi Dave Thanks for the quick reply. I am trying to accumulated sales trends by item by month. I need to show what a customer is paying by month in order to make sure the saleman has charged enough to cover costs. Item prices are individual to the customers and price increases are left up to the salesman. This process is a management check to ensure the salesman is putting through the increases. My pivot table worked fine until we reached 65000 plus records. I was hoping that I could simply name two ranges to one pivot table, but either it can't be done, or I just haven't figured it out yet. "Dave F" wrote: You can use multiple ranges in a pivot table, however, you should be aware of two issues: 1) You may have memory issues if you don't have a large amount of RAM (more than 1 gigabyte, and 2) You will likely run out of columns (max of 255 in pre XL 2007 versions). If you have that much data, a db package like Access is probably a better bet. What exactly are you trying to summarize? "Ellie" wrote: My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or mor large excel worksheets to create one pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Can I combine two worksheets into one pivot table? | Excel Worksheet Functions |