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

“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

I am needing help modifying my Pivot table. I have a Pivot table but I cannot open the Pivot table options.
Solved by C. W. in 18 mins
Im using excel and it wont let me create a pivot table nor will it give me options to sort columns. it give me two options font and color. I need more sorting options like alphabetical order. or alphabetical 1st then numberal 2nd command. Ive never had this issue before using excel. usually the options are just available . Please advise?
Solved by K. S. in 20 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
I need help creating drop down options in a table.
Solved by B. W. in 19 mins
I have VBA code that manages to create a new pivot cache for a pivot table (the data is in one worksheet and the pivot table is in another worksheet - but same workbook) - however, the refreshing of data is not successful and I'm stuck as to why because the other pivot tables are working fine and update with VBA code... I've tried PivotCache.Refresh and I've tried PivotTables.RefreshTable options; I'm stuck. When I do this manually - it updates, just not in code...
Solved by K. H. in 25 mins