+ Reply to Thread
Results 1 to 7 of 7

Auto Refresh Pivot Tables Excel 2016 for Mac

  1. #1
    Registered User
    Join Date
    01-06-2017
    Location
    Quilchena, Canada
    MS-Off Ver
    2016 for Max
    Posts
    7

    Auto Refresh Pivot Tables Excel 2016 for Mac

    I would like a Pivot Table and Chart to refresh automatically when the source data has changed. I have tried some VBA codes that were posted on the internet but they made Excel crash.

    Any suggestions? Look forward to your input.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    Try below.
    Please Login or Register  to view this content.
    If this doesn't work, upload sample workbook which mirrors your actual workbook set up.

  3. #3
    Registered User
    Join Date
    01-06-2017
    Location
    Quilchena, Canada
    MS-Off Ver
    2016 for Max
    Posts
    7

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    That line itself did not work. I am not familiar with VBA. Is there anything else that needs to be entered? Attached is a part of the file that I am working on with the Pivot Table.
    Attached Files Attached Files

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    Depends on what event should trigger refresh.

    If you want the pivottable to be refreshed when your workbook is opened.
    Place below code in ThisWorkbook Module.
    Please Login or Register  to view this content.
    If you need some other event to trigger refresh of the table. You'll need to specify what should trigger pivottable refresh.

  5. #5
    Registered User
    Join Date
    01-06-2017
    Location
    Quilchena, Canada
    MS-Off Ver
    2016 for Max
    Posts
    7

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    The trigger should be the location in the attached spreadsheet. As soon as the location of one of the units changes, I would like the table to refresh. I have tried a similar line as CK76 has posted, but that crashes Excel...

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    Then in Sheet1 module. Something like below.
    Please Login or Register  to view this content.
    See attached (fixed broken link etc).
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-06-2017
    Location
    Quilchena, Canada
    MS-Off Ver
    2016 for Max
    Posts
    7

    Re: Auto Refresh Pivot Tables Excel 2016 for Mac

    That seems to work. Excellent. Thank you very much...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dates as columns/rows in pivot tables Excel 2016
    By RoyKass in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-29-2016, 08:57 PM
  2. [SOLVED] VBA - Auto refresh Pivot Tables
    By Wallyguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2015, 03:03 PM
  3. Auto refresh pivot tables when data changes with slight twist
    By rs1aj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2015, 11:25 AM
  4. Auto-refresh pivot tables in worksheet_change event?
    By 1eyedjack in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-01-2012, 03:00 PM
  5. Auto Refresh Pivot Tables
    By Marcus Hartley in forum Excel General
    Replies: 2
    Last Post: 06-03-2007, 12:49 PM
  6. Pivot Tables -- Auto Refresh
    By Aastha in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 03:15 PM
  7. [SOLVED] Excel Pivot tables refresh
    By Dkso in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1