+ Reply to Thread
Results 1 to 2 of 2

vba code to update all pivot table in workbook but file size is ( 100 mb )

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    vba code to update all pivot table in workbook but file size is ( 100 mb )

    Hi friends,

    Please help me in fixing this,i have file with 100 mb size.

    a) i need to open the workbook and
    b)Refresh all pivot tables in all sheet.
    c)Also there are many formulas in the workbook that needs to be updated as well.

    if i do it manualy i takes more time.......for opening and refreshing and i could see status bar running for excel calculation for updating all forumulas.

    Could you please suggest me a eg. vba code. to do all above three activities please.

  2. #2
    Registered User
    Join Date
    04-04-2013
    Location
    Prague
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: vba code to update all pivot table in workbook but file size is ( 100 mb )

    HI,

    put this code in ThisWokrbook in your file. It will refresh everything in your file after openening and give you message "Updated"

    Please Login or Register  to view this content.
    cheers,

    Tomas

+ 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. Pivot Table Workbook File Size
    By Airdrielad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2010, 12:45 PM
  2. [SOLVED] reduce size of pivot table file
    By zapadias in forum Excel General
    Replies: 0
    Last Post: 05-19-2006, 05:10 AM
  3. pivot table cause file size to grow
    By Grd in forum Excel General
    Replies: 0
    Last Post: 11-10-2005, 02:15 PM
  4. VB code to update existing Pivot Table
    By suzetter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2005, 06:49 PM
  5. Pivot table - size of file?
    By carolyn in forum Excel General
    Replies: 1
    Last Post: 06-17-2005, 01: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