pivot cache

  1. T

    Pivot Table renamed items "myItem" -> "myItem2". Why?

    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...
  2. F

    Specify Selection as Range in Pivot Table Macro

    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...
  3. S

    Can the Pivot Cache "Drill Down" feature be used in other cells?

    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...
  4. C

    OLAP Pivot table - drop down data not getting refreshed

    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...
  5. W

    Pivot table and pivotcaches not pulling correct data from source.

    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...
  6. S

    Facing "out of memory" issue while importing data from a .csv file to create Pivot Cache

    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...
  7. D

    Pivot cache

    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...
  8. C

    Change Multiple pivot table's data source at one time

    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...
  9. K

    Problem with Excel memory

    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...
  10. S

    Pivot Table w/OLAP cube connection- restore defaults after user edits

    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...
  11. R

    Excel 2010 Pivot Table Change Event Issue

    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...
  12. MarkCBB

    Grouping dates on PivotTables

    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...
  13. cgeorge4

    MacroProblem-PivotTable on multiple worksheets

    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...
  14. C

    What is the nature of Pivot Cache; Data Source Drift

    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...
  15. M

    Pivot Cache with VBA

    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...
  16. J

    Maximum Number of Fields in Pivot Table?? -WEIRD!

    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...
  17. N

    Can I read a data on pivotcache by vba, not double-click(Showdetail)?

    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...
  18. S

    Pivot Tables

    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...
  19. H

    VBA select all sheets containing "-DR"

    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!
  20. Jon von der Heyden

    Append data to pivot cache

    Hi I need to construct reports where the data easily occupies more than 65k rows (usingh xl2003). Reports are outputted as pivot tables. I have managed to understand how to create pivot cache but now I would like to know if it is possible to append data to an existing pivot cache. I would...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top