Get instant live expert help on I need help with pivot table name

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

A Pivot Table question. I have a spreadsheet with 17500 rows, and columns comprising name date and amount. There are at least 12 rows per name. I would like to place a total at 'change of name' together with a page break is possible. Can I do this using the Pivot Table tool? Lynn
Solved by K. S. in 19 mins
I need help with creating a pivot table that shows name even it has no data
Solved by D. H. in 27 mins
I need help making a pivot table where I can display which salesperson sold the most in any particular month and a someone using the pivot table can click on the Pivot Table, choose a month, and have the name of that person appear with his or her amount for that month.
Solved by M. H. in 18 mins
I need help fixing an error in one of my pivot tables? The error that I receive is the following. The pivot table name is not valid. to create a pivot table report , you must use data that is organized as a list with labeled columns.
Solved by K. A. in 23 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins