MrExcel Publishing
Your One Stop for Excel Tips & Solutions

One pivot chart from two spreadsheets


Posted by Marcie on February 14, 2001 10:50 AM

I have a large spreadsheet that will soon exceed the row limit in Excel. I am going to split it into two sheets. I have one pivot table (one Page item, Four row items and four data items) that is currently produced from the spreadsheet. I need the existing pivot table (or a new one) to access data from both sheets. I tried the 'consolidate' option, but it doesn't seem to do anything like what I need. Am I going about this in the wrong way?


Posted by Mark W. on February 14, 2001 11:37 AM

Marcie, you'll probably have to maintain your data
an external text file and access it using Excel's
ODBC Text driver.

Posted by Marcie on February 14, 2001 3:37 PM

Thank you Mark! Your solution worked great!