I'm trying to create a pivot table that has data from two different worksheets in the same file.

I've defined Named ranges, for example: Maine_IDs, Maine_Stores, Utah_IDs, Utah_Stores. In the Maine worksheet there is a column named IDs, and one named Stores, and in the Utah worksheet there is also a column named IDs, and one named Stores.

I've tried using the PivotTable and PivotChart Wizard to create a pivot table using all of this data. I use the option for "Multiple consolidation ranges", and in Step 2, I select, "I will create the page fields."

All goes well, I enter in each Named range, it gets added to the list in the Wizard, but then at the very last step, it tells me, "The command requires at least 2 rows of source data....".

Any ideas on what I'm doing wrong, or what I can do to make this work?