+ Reply to Thread
Results 1 to 4 of 4

Update pivot tables based on source data filter

Hybrid View

papasmurfuo9 Update pivot tables based on... 02-11-2014, 07:26 AM
papasmurfuo9 Re: Update pivot tables based... 02-11-2014, 08:56 AM
papasmurfuo9 Re: Update pivot tables based... 02-26-2014, 07:22 AM
papasmurfuo9 Re: Update pivot tables based... 02-26-2014, 08:03 AM
  1. 02-26-2014, 08:03 AM #1
    papasmurfuo9 is offline
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Update pivot tables based on source data filter 

    ActiveSheet.PivotTables("MonthlySummary").ChangePivotCache ActiveWorkbook. _
PivotCaches.Create(SourceType:=xlDatabase, SourceData:=
    my starting point

    but i need the source data to point to the viewable data by filter in a sheet
    Last edited by papasmurfuo9; 02-26-2014 at 08:15 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Macro: Filter all pivot tables in workbook from a source(reference)
    By moxman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2013, 09:46 PM
  2. One filter/ Master filter multiple pivot tables based on worksheet...
    By jlworden in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-10-2013, 11:16 AM
  3. [SOLVED] Update source data for multiple pivot tables on same worksheet
    By Platinum3x in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-19-2013, 12:11 AM
  4. Excel 2007 : Change pivot table source data for multiple pivot tables simultaneously
    By jjlad in forum Excel General
    Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  5. Display source data from Pivot Tables (field to filter has too many unique values)
    By Excel_pivs in forum Excel General
    Replies: 0
    Last Post: 07-21-2010, 01:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1