2013 excel

I am receiving this error: Run-time error '1004' Unable to get PivotFields property of the PivotTable class This is occurring for me in Excel VBA (version 2013), but the same code executes successfully on a different machine running Office 365. With pt .PivotFields(fieldName).ClearLabelFilters...

Hey guys. I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate...

Hello, Is there a way to set each new pivottables to classicview by default in Excel 2013 ? Thanks in advance.

Hi There I'm stuck...Please help..:eeek: I'm a request fulfilment manager, and I have an Excel sheet which is an extract from our Helpdesk system. It's 70.000+ rows. Here is my challenge: In colum A I have a unique number for the specific Request i.e. RFxxxxx and in colum B I have an URL that...

Hi I have pivot tables obtaining data from SQL Server and I just noticed that one of the columns is cut off after 255 characters. This is for 2013 Excel. I have been looking everywhere for a solution to this as this is for work and only seeing for older versions and within cells but not for...

I've got a dilemma I am faced with. I have a sheet that has GETPIVOTDATA formulas that I have created a BeforeDoubleClick Event that opens a new sheet containing the data reflected in the GETPIVOTDATA via VBA code. It works without issues when I click the options to allow selection of locked...

Here is the dilemma I am running into. I am designing a report that will be viewable by both managers and employees. I have slicers attached to Employee, Level 1 Manager and Level 2 Manager fields that control all the pivot tables. The issue is, once I run the code upon opening the workbook...

I have been looking for information on this and have not been able to find any. At least not the "rules" for getting this to work properly. I work with excel on a daily basis in a professional capacity and want to be able to use GETPIVOTDATA at times but some tables don't allow it and instead...

I'm stumped. I was prompted by many to switch to 64 bit Excel because I load and work with large files. My company has approved 2013, but not 2016, meaning I still can't use Power Pivot fully (2013 is still a bit buggy). and for the present that's OK. However I have a recurring issue when...

I'm really struggling when trying to understand how Excel deals with number representation. It would appear that (1.2 / 0.2) and (12 / 2) are NOT the same. Although both results appear as '6' in the formula bar, I noticed that in a pivot table, Excel 2013 was not summarising both values...

Hi guys and girls, I'm pretty familiar with the windows version of excel. I know that not everything carries over to the mac version but I was hoping that The ability to select multiple non adjacent cells at once was one of them. To do this on a windows version of excel all one has to do is...