+ Reply to Thread
Results 1 to 1 of 1

Excel 2010 Macro Refresh Pivot and Formulas

  1. #1
    Registered User
    Join Date
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003

    Excel 2010 Macro Refresh Pivot and Formulas

    Not Relevant Just FYI *In columns A-L the data populates from an Excel Add In, and columns M-AN are formulas that calculate from this data*

    Column BS on the far right, I copy and paste in data from a different workbook each day to update the data, and this column links to Column P.

    There are two pivot tables that stem from this data, and two formulas to the right of these two pivot tables.

    The 1st formula in column AS, takes references a value in another worksheet to populate.
    The 2nd formula in column AT, just subtracts thw two total columns.


    After I update the information from the Add In and copy and paste new values into column BS:

    I want the pivot tables to automatically refresh (pull down so the new day's data is included), AND I want the formulas to also pull down for the new day's data as wel.

    Any help or advice or something I can put in is greatly appreciated as I have a similar situation to this in a lot of workbooks.

    Also, one thing to keep in mind is thatthe Pivot tables source date is pulled far down in the worksheet, so I do not have to continously change the source data reference. Thus I can't choose 'Select All' on the pivot table because "(Blank)" will appear in the table.
    Attached Files Attached Files

+ 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. Refresh Macro: Formulas and Pivot Tables in Specific Order
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2013, 11:04 AM
  2. Please help! Macro with dynamic range and pivot table Excel 2010
    By sassylogo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2013, 10:31 AM
  3. Conditional icon formatting in pivot excel 2010 to stay with refresh
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2012, 04:22 PM
  4. Tracking Sheet / Pivot Table Refresh / Fill Formulas
    By exc4libur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2011, 11:44 AM
  5. Problems with refresh in excel 2010
    By Ron1121 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2011, 10:15 AM


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