pivottables

Hi, I've a code which runs to refresh all pivots I've listed in an excel file with a specific data source, also listed in the cells of the excel file. The code is able to execute, and refreshes the data, however, the data source range becomes corrupt after? It throws me error: "The PivotTable...

Hello. New member. I had a situation with a dashboard (Excel 2013) that consists of various tables, charts, and text. We been asked to expand the backend data and allow a user to choose their own dates. At first I thought this would be easy by way of Slicers and the Timeline function...

So I need to capture the Name and corresponding Total. Notice that the Employee total is varying cells below the name - For Bobby Jones its 3 down and Ricky Bobby its 4. For example the desired data would read like this: <tbody> A B 1 Bobby Jones 300 2 Ricky Bobby 1,100 </tbody> The...

I have a big data set that I use for some pivot tables here at work. I use the dataset to run 4 pivot reports.. but all of the reports come from the same dataset. How do I create a macro or slicer to arrange pivot table field lists with the click of a button?

hello everyone, i have a huge problem and i hope you can help. i'm using excel 2013 and i bulit a very big excel that has about 20 pivot tables. when i built them i used the "add this data to Data Model" option and now i send this file to a client for him to use. the client is using excel...

Hey guys. Can someone please help me with this small issue I have. I know there is an easy fix I just dont know what it is. I have an Excel sheet in which i update data frequently. I have 10 pivot tables for various things in one of my Excel workbooks and one of the columns have hyperlinks to...

Hello - I need to fix this code so that I can apply it to numerous reports that are never the same size. CopyNames3 = I copy the names so that when I filter out statuses other than "COMP", I don't potentially lose an employees name in the pivottable. FilterStatus = this range also needs to...

Hi Everyone, Been stuck with this problem for the past hour and just cant seem to get this code to work. From my perspective I am referring the code correctly and the code runs through and gives no issues, however the code is not filtering the pivot table at all. Look forward to your...

I use a data set with some significant shortcomings, and I'm trying to find ways to save myself a little time when pulling reports. Can anyone give me some guidance on setting up a field filter that I can save (in this case "Customer Name"), and apply against future data sets? My data is...

Hello all, I have data in 2 separate workbooks. In the first one I have data that includes a column that contains textual data that matches with (in different order) a column in the other workbook. I have a number score in a column that's next to the text column in the 1st workbook (ex. 1-100)...

Hi, in need of some assistance. I have a pivot table that displays information on servers, which has been pulled from a worksheet. Lets call it this worksheet SERVER INFO Location code, OS, server role, etc In another worksheet I have location information. Lets call this LOCATION INFO...

Hey Everyone, I have several pviot tables organizing data based on month and year with grouping. At this point, the data does not order properly unless there is a date in every single field. Is there a way to have a Pivot table group a set of data by dates and have it exclude a value when...

Hello! I am running into an error when creating a macro to make a pivot table and sum certain columns. I am fairly certain this is due to the name changing to PivotTable2, 3, 4, etc. each time. Is there a way to make the name stagnent so when a table is created in the macro it doesn't error...

I have a pivot table that contains currency values. I have been working with this spreadsheet for a while, and in the past it always allowed me to format cells as currencies. Suddenly today it refuses to budge. I change the format of a cell to currency, but the display does not change. Pivot...

I am trying to track changes in a complex workbook with pivot tables and macros. This worked fine on a basic trail, but when used on the complex spreadsheet and we tried to print , we got a run time error 1004 - you cannot create or make changes to PIVOTTABLE reports in a shared workbook. Does...

I've recorded a macro to create a pivottable and then tried to amend it to pick up a defined range I'm getting run time error 5 when I try to run it the code as far as the error is as below Dim MyRange As Range Range("A5").Select Selection.CurrentRegion.Select Set MyRange = Selection...

Hi, I have a pivottable where I want to "filter" some data depending on if they are in other table or not, the data I want to filter are alphanumeric names. My idea is to save the data (names) in an array and then compare the pivotitems to the array items and set visible the matches but it...

Hi there, I am trying to write some code that will refresh an unknown about of Pivot tables every 30 seconds. The Pivot tables are on different worksheets but all are in the same workbook. the name/numbering (PivotTable1,2,3) of the pivots are not contiguous. I have just started with VBA...

Howdy folks, I've been working on this problem for quite a while, and I can't get it to work properly. I am creating a macro for someone where data is consolidated from multiple worksheets into two summary sheets. From there, based on options selected on a "setup" worksheet, multiple...

I used the record feature to pick two categories "Sum of vol_gross" and "Sum of vol_net" and put those in the Data field. After the table was created I dragged them both to the Totals area so that it reflected the correct values. For a while the vol_gross was in column J and vol_net in column K...