Auto Update Pivot Table issues



I am having issue having pivot tables automatically updating. I am trying to use the code ThisWorkbook.RefreshAll

Tab 1 is going to be my dashboard

Tab 2 is main data tab

Tab 3 is consolidated data from tab 2 to create a chart.


The information I am trying to pull is the belo

Column A – Work Order #

Column B  – Efficiency %


Work Order number is manually typed in. Efficiency % is copied over from tab 2 with formula =’Employee Data & Work Order Data’!F46

That information is calculated in tab two by a series of number with the formula =IFERROR(H54/I54, “-“)

Anytime I update Tab 2 the efficiency % changes on both tab 2 and tab 3. However with the VBA code above input the pivot table on tab 1 does not update. If I remove the formulat in the cells in Tab 3 and manually enter data the pivot table will update. I need it to update with all formulas in tact.

I can send file if it is easier

By: Adam

63 thoughts on “Auto Update Pivot Table issues

  1. Reductil kaufen

    I am very happy to read this. This is the kind of manual that needs to be given and not the accidental misinformation that’s at the other blogs. Appreciate your sharing this best doc.

  2. Kaufen

    Hi there, simply was aware of your weblog via Google, and found that it is really informative. I’m gonna watch out for brussels. I’ll be grateful if you proceed this in future. Lots of folks might be benefited from your writing. Cheers!

  3. Buy Phentermine UK

    I like what you guys are up too. Such smart work and reporting! Keep up the superb works guys I?¦ve incorporated you guys to my blogroll. I think it will improve the value of my website 🙂

  4. Buy Reductil online

    Thank you for sharing superb informations. Your site is so cool. I’m impressed by the details that you’ve on this site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found just the information I already searched everywhere and just could not come across. What an ideal website.

Leave a Reply

Your email address will not be published. Required fields are marked *