+ Reply to Thread
Results 1 to 3 of 3

RefreshAll

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    Bangladesh
    MS-Off Ver
    2013
    Posts
    72

    RefreshAll

    I have a Excel Macro workbook with 300 Worksheets.

    It takes long long time to Refresh all the pages, it takes almost 6-8 hours with 2mb bandwidth.

    Are there any way to refresh all the pages quickly,

    Please help.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: RefreshAll

    When you say Refresh what exactly do you mean?

    Does your workbook have a number of links to external documents/website etc? Im assuming it does because you talk about your internet speed.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    Bangladesh
    MS-Off Ver
    2013
    Posts
    72

    Re: RefreshAll

    Yes , My workbook has 300 worksheets and each sheet extract data from web sites. My Internet speed is 4MBS. I have one Refresh button for all 300 work sheets. But it takes long long time to Refresh all the sheets. Are there any way to faster the Refresh? Please help.

+ 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. Activeworkbook.Refreshall skips some connections
    By Phillip.C in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2014, 10:34 AM
  2. .activeworkbook.refreshall
    By MelissaGregory in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-03-2013, 07:36 PM
  3. RefreshAll PivotTables failing
    By philtucker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2013, 01:17 PM
  4. Refreshall external data
    By hilander in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2008, 03:16 AM
  5. RefreshAll not quick enough
    By WhytheQ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 09:20 AM
  6. [SOLVED] ActiveWorkbook.RefreshAll
    By Matt Cromer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2006, 03:50 PM
  7. RefreshAll / Protect Help Required
    By AndreLaplume in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 01:00 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