pivot cache

Hi, I would like to change the source data of my pivot table, from one location to another. The new data is in a different location. appreciate any guidance Thank you

Hi everyone, this is my first post. I have a table in excel like this: <tbody> State City NY New York NY Albany FL Miami FL Tampa Washington Seattle </tbody> Then I created a pivot table and played around, adding lines, changing values on the table. Etc. The problem is...

Hello all, I want to specify the active selection as the range for my pivot table but I keep getting an error message. Funny thing is this recorded code always used to work before but for some reason its not working anymore. The only change I had made in the recorded code was changing source...

Good Day, For my first post I'd like to know if it is possible to use the "drill down" feature of a pivot table within a cell out side of that pivot table. I am using Excel 2010, on Windows 7. The end user(s) will have these (at a minimum) or newer. I have a report that tracks inventory a...

Hi (I have been advised to re-post the question in Excel or SQL Analysis services forum)I have two Pivot tables which are connected to an OLAP Cube and the data in table gets refreshed when Data->Refresh->Refresh All is done, but for some reason the drop down list does not get refreshed. There...

Hi. I'm having an intermittant problem with Excel 2010 which for some reason is pulling out a value of #n/a rather than the actual value in the field in the source data: Data Structure/Flow: ----------- Microsoft Access Table 1 -> SQL Database Query -> Excel Workbook A, Sheet 1 Excel Workbook...

Hi All, I need a help on this issue which we are facing. We are trying to create pivot cache from an external .csv file. This works fine when the csv file is small (<500 mb). But it given "out of memory" error for bigger .csv files(>~500 mb). Attaching sample code for reference - Dim...

Cannot figure out how to control pivot caches. (In Excel 2010 now. Learned them in E2000 and have struggled since E2007.) Researched. Read books and posts. Have played around for a while. 1) See page 41 of Jelen/Alexander book PT Data Crunching. Want to use old wizard (Alt+D then P) to...

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, Generel overview of Excel Sheet: I use two Excel workbooks. One where I start my macros, creates my Pivot table and store all the data i need. The second one, I use to extract data through SQL scripts to two worksheets and connect them through a lot of VLOOKUP functions and doing a lot of...

I've searched everywhere for the answer to this for 48 hours now and I really need some help. We're using a pivot table with an OLAP cube connection and we're getting false-positive results because of a user error. We have 4 row labels to classify the data and we're experiencing problems with...

Hi, I have three worksheets Sheet 1, Sheet 2 and Sheet 3 with three PivotTables Sheet1 - Sheet1Pvt1 Sheet2 - Sheet2Pvt2 Sheet3 - Sheet3Pvt3 When I use In Sheet 2 the following lines of code Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) Application.EnableEvents...

Hi there Pivot Tables Gurus, I have 2 pivot tables on the same worksheet that reference the same database by using a dynamic named range. My 2 pivot tables show values by date, but I want the one PT to be by date, and the other to be by Month, however if i change the one, the other updates to...

I am so happy to have found this fabulous help site. I am extremely adept using Excel - but begining to use Macros - yet I can record, write some simple ones, and certainly understand reading them. I need a macro that will create a pivot table on all my worksheets within my workbook. Here...

A Good Morning to All: I am working in Excel 2010. I created a workbook for distribution where the user will make a copy of the workbook posted in a central location, then paste the copy a local area of their own choosing. With the workbook I have several functions which work the same. I am...

Working with a few hundred thousand rows of data on Excel 2010 but I can't get my macro to create a PivotCache / PivotTable from my data. The code I'm using is Dim PC as PivotCache Set PC = ActiveWorkbook.PivotCaches.Add(xlDatabase, Sheet1.Range("A1").CurrentRegion) It works fine as long as...

I have a confusing VBA problem/bug that I don't know how to work around. 1. I define a pivot cache with 70 columns (this works fine) 2. However, I need 71 columns or else the calculated field I need won't show up in the field list. 3. But, Excel 2007 won't let me add a 71st column. 4. I've...

Can I read a data on pivotcache by vba, not double-click(Showdetail)? I want to read a data on pivotcache directly and fastly. Regardless of whether its sourcetype is an internal source or an external source. Assuming that I have a data that have 60000 rows, Because of Autoformat after...

I have a question about Pivot Table data....i.e. the data behind the Pivot. Basically there is a report distributed around the firm... in the form of a very large pivot table with all the Pivot filters hidden and formatted so it just looks like like a few tables. But the source data has been...

Hi, How do I write a macro that will select all sheets containing the test "-DR"? Hopefully someone can also tell me how to select all pivot tables in those sheets once I've done this... Thanks!