re: Pivot Table help with creating a new workbook and adding multiple tables onto one sheet

[excelrookk]

re: Pivot Table help with creating a new workbook and adding multiple tables onto one sheet

I'm trying to add multiple pivot tables to my spreadsheet and after adding one, it gives an error, "Destination reference is not valid".

Also - Is there a way to generate results of pivot table filter in a new workbook? anytime I use any filter using pivot tables?

Thank you in advance for your help.