Item in page field in Pivottable

T

Tobias Lundgren

I am creating a pivottable from several different
worksheets; this works just fine, but my pages are all
called Item1, Item2 etc, not there names. Why? and how
can I change it to there real names?
 
B

BrianB

Unfortunately that is the way it works.

The only alternative is to add everything to 1 table
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable - Show labels on every row? 1
PivotTable Calculations 12
Trying to SUM variable number of VLOOKUPs 7
PivotTable - feature like "value range" or "slices" available on regular fields? 0
Document won't print 0
Multiple "Not Like" not working 10
Grouping Names in Mail Merge 0
Page numbering with Merged Document and IF statements 1

Top