Share via

Pivot Table automatically auto update when data changes

Anonymous
2019-01-24T19:18:16+00:00

Using the latest Office 365 Mac and have a Pivot Table on the same sheet as my data.  I want the Pivot Table to update automatically when data is changed in the spreadsheet.  I have it working when closing and reopening, but can't get the automatic part to work.  The pivot Table is on the same sheet as the data, in this case sheet 1.  The file is saved as a .xlsm.  Do not know how to make the VBA work!!  Thanks for the help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2019-01-24T20:14:47+00:00
  1. Make a backup of your workbook.
  2. Open your workbook and ALT+F11
  3. Locate your Workbook name in Project Explorer Window
  4. Double click on your worksheet name
  5. Copy paste the Macro code given below
  6. Save your file as .xlsm Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ExitSub If Intersect(Target, Me.Range("A2286:O2386")) Is Nothing Then Exit Sub Application.EnableEvents = False ThisWorkbook.RefreshAll ExitSub: Application.EnableEvents = True End Sub

Was this answer helpful?

1 person found this answer helpful.
0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-24T20:06:03+00:00

    Sorry

    A2386:O2386  O THE LETTER

    Was this answer helpful?

    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-01-24T19:38:10+00:00

    Is it A2286:A2386?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-01-24T19:33:25+00:00

    A2286:02386

    Was this answer helpful?

    0 comments
  4. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-01-24T19:25:08+00:00

    Hi AZ16,

    I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    A change event will be needed for this. What is range where your data can change?

    Do let me know if you require any further help on this. Will be glad to help you.

    Was this answer helpful?

    0 comments