pivots

I built a dasboard, it allows you to log on and se departmental information. When it does it links a couple of hidden slicers that only allow person to see into their department. When user logs out back to general view I want to make sure the slicers are not somehow going cause data to be...

Hello, I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me. The project I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between...

Hello, I have a few pivots all sorted by dates and regularly filter using the "this week" "last week" filters. Is it possible to create a slicer to do this? or something similar? Thanks Stephen

Hi All, I've written a some code to hide charts and pivots the charts part works perfectly however as i have 12 pivots all feeding from the same source when i try and hide one of them using "tablerange2.entirerow.hidden = true" all of the pivot tables are hidden not just the one selected. I...

Hello, I have the below bit of code within a larger piece of code which is working as intended - looping through each slicer item, and selecting/deselecting if the date meets the specified criteria. My issue is that as my data increases, there are more and more dates to loop through, and it's...

Hi team, So I made a great new spreadsheet, and after testing etc. I moved it to the work drive, and low and behold, none of my pivot tables will update! When I select 'Change Source' it only lets me adjust the file name, not the file path. The pivots only refer to information on other tabs...

Hi Excel Gurus I currently have an existing Pivot table. I have been looking on line to find a way to have the existing pivot table to look into multiple tabs. I already have the tabs named. The only thing I found at this point is how to create one from scratch. However, I don't want to do it...

Hi! I need your support guys, in a big file I am working on I have the following table: <colgroup><col><col><col></colgroup><tbody> Group Dept Owner Name 1 A Adam 1 B Alex 1 C Bryce 1 D Carmen 1 E Eric 1 F Giovanna 1 G Jane 1 H Manuel 1 I Robin 1 J Rocio 1 K Tabba 1 L...

Hi All, How to integrate contents of rows as headers in values field of pivot table. Please find the attached to understand the question better. Thanks in Advance Divakar file:///C:/Users/divakar_k/Desktop/Mrexcel.JPG C:\Users\divakar_k\Desktop\Mrexcel.JPG

HI, I have the code below which works fine to update a single pivot table (PivotTable3) which is on Worksheet "P&L Analysis". The sheet "P&L Analysis" contains another two pivot tables named "PivotTable10" and "PivotTable11" which I would also like to update automatically. Can anyone tell me how...

Windows XP, Excel 2007 Please can anyone tell if it is possible to group months in the columns in a pivot into quarters or years, and return the last value of a period when grouping. I have a pivot with several items under the rows field, and for most of these items it is appropriate to sum...

Excel 2007 windows XP I am trying to group columns of dates so that they show either quarters or years when the initial data is by month. The problem I have is that I want the results to show the total qrt/year as an average in the 'summarise value field by' within the field settings. However...

Hello, I have two pivot charts on 1 worksheet. Pivot 1 Pivot 2 True/False Form Returned Goods Total Goods 200+ List of customers 2000+ List of customers That is the basic setup of...

Hello all, I am trying to automate a report to send tables via outlook. I am summarizing the data in a Pivot however I am getting an error as soon as it starts the first loop. I think is may be some kind of sheet naming or activation error but I'm really not sure any ideas? I've bolded the...

Hi all, Although I have developed excel apps using vba in the past, my new project has a requirement to have no vb code and is to generate all output via pivots - and quess what, if I am honest, I've never really used them. So I need to get up to speed quick. I am comfortable with the use of...

Hi All, I have been working on a project for nearly 2-4 months. I have completed the project and it is working perfectly (VBA Report). I have over 8000 lines of code so you could say I know a bit about VBA. I have done alot of other programs too. Now to the matter in hand. I know how to select...

Dear all, I have been trying to create a macro that: 1) opens all my excel files in a folder 2) adds a new connection to each file 3) for each pivot table (of each sheet in each file) that is linked to my data cube, I instruct the macro to replace the existing connection and replace it with...

I really like the slicers in Excel when working with data scenarios, but I don't like having to scroll up and down through the list of options. Is there a way to add a "Search" box at the top like the traditional drop-down auto-filter? Or, does anyone know a loophole to making one? I feel like...

Hi - I publish a rather large pivot table monthly of sales data currently in Excel 2010. As a resulting of some of the enhancements with pivots in 2013, my company is considering upgrading my machine, however if I create a pivot table in 2013, save the file...publish it to users of excel...

Hello, I am dealing with testing of software and not using any testing software for it but just sharepoints and excel. The problem we run into is having to deal with hand offs between testers and not knowing whats coming next for which work stream. I was wondering if it is possible to pivot...