pivot table 2010

Hi, I am currently trying to build a slicer that is connected to multiple pivot tables. However, these pivot tables contain grouped fields so an ordinary slicer will not work. That being said, I am attempting to build a slicer lookalike in VBA that can accomplish slicer like capabilities...

I have written Excel VBA for years but never for creating Pivot Tables, I will be starting a new project that requires Pivot Tables. Can anyone suggest a good article or a good link for general pivot table tips and tracks using VBA? I have Excel 2010. Thank you!

Hello All, Could some please advise how I go about creating a pivot table using data from multiple worksheets. All column titles are the same however row titles are not. Is this possible? Thanks

I am using Excel 2010 I have 1 pivot table using 2 slicer objects. When I use slicer 1 it automatically shows what I can filter in slicer 2. If I filter in Slicer 2. Everything works great. When I come back to slicer 1 and select an item that is greyed out. the slicer fails, till you clear the...

After creating the Pivot Table shown below https://www.dropbox.com/s/80fys3eb9ovbmyc/Pivot1.jpg I want to get a continuous list of dates with the year included as shown below https://www.dropbox.com/s/hdo7yea6usckx7u/Pivot3.jpg In order to get the data organized as shown above, I have copied...

Greetings, I am having trouble creating a macro that will create a PivotTable using range variables from a dataset, and insert it into a new worksheet. Any ideas what I am doing wrong with this code? Thank you: Sub CreatePivotTable() Dim r1, r2, r3 As Range Cells(1...

I'm working in Excel 2010. I have a pivot table that's accessible to my entire firm. The source data for the pivot table is stored within another worksheet file separate from the pivot table. I want to restrict other individuals within the firm from being able to access the source date...

Hi, </SPAN> I am working on an Excel spreadsheet with a few pivot tables. The end goal is to have 53 PDF's of the spreadsheet (Sheet3), stored in a folder, with the filename as the Organization </SPAN>name that is reflected in the pivot table. I will be doing this monthly so the variables in...

Hi, I have a Excel list for Sales data with 1 record per salesman/period. I have created a pivot table in compact form from that list where in the Report Filter section, I have the period (year/month). In the Row Labels section, I have Cluster/Dept/Salesman. In the Values section, I want to...

Hi All, (sorry for wordy post) A VBA newby, but I've tasted the CoolAid and I know how powerful it can be so I'm trying to improve my skills. In short, I'm trying to create a process to pull select data from a pivot table and copy it to a specific range on another sheet. The pivot table has...

Hi all - I have an worksheet style database in Excel that contains information on several firms over several periods. Each measure is in the firm's native currency (USD, CAD) and I also have a column with the converted currency (CAD). In my Pivot Tables, I would like the ability to sum to one...

Hi, I have a workbook with several pivot tables and created slicers to manage the data showing. I have noticed that when i now create a new pivot table in the workbook, the slicers do not allow me to connect to the new pivot table. Thinking that it may be something to do with the slicers, i...

Hi, I have a Pitvot Table that I would like to sort but for some reason the AutoFilters are not sticking. I can't figure out what I am doing wrong? Is there something in 2010 that needs to be activated before the AutoFilters will work? Any help is appreciated!

Hi, I am just starting to learn about Pivot Tables (Excel 2010), and have a question that is probably painfully obvious to you pros - so please bear with me! In the work sheet, I have a sorted table consisting of 2 columns: Column A contains one of 3 stores, Column B contains merchandise. I...

Using Excel 2010. Using a Pivot Table to sum "quantity sold" for a list of items. I am also pulling in the "description" field for each item but some items have 2 descriptions, thus creating two rows and in my pivot table for items with 2 descriptions. I only want 1 description per item and I...

I have a doucment with many sheets, one pivot table per sheet. I would like to use a macro to change their data sources all at once to the same data source. I found this code wich I would like to use as the data source..this ensures there are no extra empty cells (which causes my Value Field...

Hi, Is there a way to create a bubble chart from a pivot table? The rows include names of opportunities, and I want to include the bubbles to represent Profit size of these opportunities (large profit size = large bubble) along a time horizon (horizons 1, 2 and 3). The Y axis would represent...

Hi, I have had a decent google and haven't managed to find an answer that suits my problem. I have created a pivot table with 2 columns of data (as an example). I have added a subtotal to the row of data which is just summing the row label. Like this example for a debtors report: Row Label...

I want to show from a set of values that for some values there is a high count and for others a count of zero (result in both tabular and chart form). I make a pivot table with my range of values drug to both the Row Labels and the Values (as Count) and it works for for values where the count...

<dl class="userinfo_extra" style="margin: 5px 0px; height: auto !important; float: left; width: 180px; "><dd style="margin: 0px; padding: 0px 0px 3px; "> </dd></dl> pivot table error but still updatesI have a workbook with 6 worksheets. One is the source file for my pivot tables, three of them...