pivot tables excel 365

Hi, I just started a new job and my manager has asked me to look into an existing spreadsheet we have. It contains quarterly data from the company's call centre, compiled for a previous project that looked into assessing how call agents performed and achieved KPIs on a quarterly basis. I've...

Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278) Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...

Hi I am trying to use pivot tables to create a series of graphs for a dashboard of sorts. I have data sets for a series of locations over a long time horizon and will be filtering by date and location. The issue that I have is the majority (but not all) of the data points are a balance/data...

I am trying to change the names of my pivot table columns that is created in a macro. The names of the columns from my data table will always change, but the locations will remain the same. ActiveSheet.PivotTables("PivotTable5").AddDataField ActiveSheet.PivotTables( _...

I wanted to know how to disable automatic sorting when creating pivot tables, and is there multiple ways to disable it or just one?

how do I loop a sub button click () so it will run data again using the same macros, but populate information in the next row down? The file that it runs is an SQL, but I need the data to go for example line C3 down the column to C4 (Module two) Sub Button2_Click() Call TXTdATA 'Macro1...

In the Image in uploaded I am trying to figure out 2 things. 1. Is it possible, without code, to double click on cell selected and not get those extra columns to show up because they are needed? 2. Or must I use code and would the code be easy to accomplish this feat? I try to look this up but...