large databases into a pivot table

M

Mike

I've created a a large worksheet of data that I then created a pivot table to
view the numbers. I am running out of room on the sheet and will have to
start a new database but is there a way I can use both the old and new
databases into one pivot table? Thanks!
 
F

Frank Kabel

Hi
if you start the pivot table wizard there's an option to choose from
different sources in the first dialog window.

BUT you may consider moving your data to a database and access this
database with your pivot table
 
Top