Excel - Pivot Table

[lauriebizz]

I've got a pivot table pulling from multiple ranges on several pages of a workbook. I added a page to the wb as well as adding it to the pivot table. Funny thing, the items show up in the column but the quantities in the data portion only show the previous pages... is there a limit to how many sources you can pull data from? I currenty have 8 tables and am wondering if the limit is 7? Any ideas?

Thanks-
Laurie

 

[SkipVought]

Hi,

Similar data in multiple places (like sheet/files) is a bad design, fraught with heartache and tears.

I'd guess that the 7 sheets have a data value associated with the Sheet Tab Name, like date, department, person, company, region.

I'd consider merging the data, along with the sheet name, into a single table.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}