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?
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...