+ Reply to Thread
Results 1 to 3 of 3

Ignore Data Connection failures

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    South Africa
    MS-Off Ver
    Office 2013
    Posts
    3

    Ignore Data Connection failures

    Hi All

    I have a spreadsheet that collects data from the web and have set it to auto refresh the connections at certain intervals. My problem is that currently my internet connection is experiencing random drops and when the sheet wants to refresh the data connection while the internet is down, it will just sit there with a message that it could not connect to the certain connection URL. Is there a way to force excel to continue to try and access the rest of my connections until the internet comes back online and continue as normal? My Excel version is 2013. Thanks

  2. #2
    Registered User
    Join Date
    11-04-2014
    Location
    South Africa
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Ignore Data Connection failures

    So does no one here know how to solve my issue?

    EDIT: Apparently not....
    Last edited by MrEx; 11-04-2014 at 08:05 AM.

  3. #3
    Registered User
    Join Date
    11-04-2014
    Location
    South Africa
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Ignore Data Connection failures

    Bump.............

+ 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. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  2. IF Statement for SLA Failures
    By Chopperchand in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-18-2012, 10:16 AM
  3. Excel 2007 : How to calculate Mean Time between Failures
    By Icehockey44 in forum Excel General
    Replies: 3
    Last Post: 02-21-2012, 08:20 AM
  4. Excel 2007 data connection not using connection file
    By algilstrap in forum Excel General
    Replies: 0
    Last Post: 06-09-2009, 03:01 PM
  5. Random Macro Failures
    By thomasrawley in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2006, 04:30 PM

Tags for this Thread

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