Get instant live expert help with Pivot Tables

“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

Hi - I want help with an embed of pivot tables. I have data on two different data tabs and want the results of one pivot to be divided by the other, ultimately to calculate conversion but in a pivot format for efficient update purposes - please can you help?
Solved by V. W. in 24 mins
I need a very complex analysis in excel to automatically generate multiple pivot tables to every time i imput data tables and multiple csv files. Professors only.
Solved by C. H. in 30 mins
How do you think go about creating twenty pivot tables from a multiple and heavy data source in excel.
Solved by X. A. in 21 mins
I'm working on a macro in excel that basically deletes the first three rows of a file, and the highlights all active cells remaining and turns that list into a table. The macro then creates 3 separate pivot tables and puts them on their own sheets as well. My question is, how can I get the macro to automatically update and create the table in the beginning when the data is constantly changing sizes? So basically when I get one worksheet of data there might be 500 lines of items but then on the next worksheet there's only about 10. How can I edit the macro so that it automatically adjusts the data area?
Solved by F. C. in 26 mins
I need help with pivot tables, i have a huge data set
Solved by F. F. in 17 mins
i have a huge data set and a question about pivot tables
Solved by Z. Y. in 29 mins
I need help with a project. This project require pivot tables and Vlookup. I need help creating pivot table bring up a skip % performance against reader. Vlookup is also needed but I am not sure how in this case. Can you help me?
Solved by T. S. in 27 mins
I need help organizing my workbook to create pivot tables & tables that are dynamic. Any help is greatly appreciated!
Solved by B. L. in 21 mins
I am trying to create a training program that will show the progression in each exercise. I need help organizing my workbook to create pivot tables & tables that are dynamic by the type of exercise through the weeks. Any help is greatly appreciated!
Solved by Z. S. in 20 mins
My Excel workbook is enormous and takes too long to save, open, and close. I have followed every suggestion online for eliminating empty cells, columns, and rows and it gets bigger every time. I even saved it in binary format and it's still too big. I don't know how to shrink the size to reflect the actual amount of data in there. There are very few formulas and no pivot tables. I can't attach the file because it's over 20 MB!
Solved by K. B. in 22 mins