large databases into a pivot table

[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!

 

[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