Excel 2016 Pivot Table Data Source Error

[water1355]

Excel 2016, Microsoft Office 365 ProPlus Version 1706.

I have what seems a trivial error that I can't resolve on my own, and I'm not finding the answer online. I have a spreadsheet with three tabs containing data dumps (from another program) of three scenarios I am comparing (tabs are scenario 1, scenario 2, scenario 3). The data in each tab is 8 columns by 12,000 rows. I want, in the same spreadsheet, three different pivot tables, one for each of the different scenario tabs. The first pivot table sets up correctly. However, when I define the second pivot table using 'scenario 2' as the data source, the pivot table that is produced shows a data source of 'scenario 1'. OK, fine, I manually reset the data source. But after doing so, the data source still reads 'scenario 1'. I can't seem to get pivot tables from more than data source in this spreadsheet.

Is this a limitation in excel that limits me to one data source for pivot tables in a spreadsheet? I'm pretty sure I've done what I want to do in earlier versions.

I'd rather not do a workaround where I have to append a scenario field to the data to put all the source data in a single table, nor do I want a separate spreadsheet for each scenario.

Thanks for your help.

 

[mole999]

have you used a named range for each set, I don't think there should be an issue. I've had sixty pivots on a sheet all off their own named sets

 

[water1355]

Thank you mole999. That solved it.