avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 4, 2021, 10:39 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - wysiwyg125 [ switch to compact view ]

Pages: [1]
Finished Programs / FINISHED: Reopen file after Wifi reconnects
« on: November 14, 2017, 09:07 PM »
Hi, first post here.
My situation is a bit complex so please bear with me, any suggestions to help flesh out what I need are appreciated.

I have an always-on computer "dashboard" that displays a log through Excel. There is a "Source" Excel file located on a network drive, and a "Dashboard" Excel file located locally on this computer. The Dashboard file has a data connection/query to the Source file, set to refresh every minute. So if someone adds something to the Source file, it gets updated on the Dashboard in near-realtime.

Here's the problem: The dashboard computer is connected to the network via Wifi, and for whatever reason it sometimes disconnects for a short time. When this happens and the Excel file tries to refresh, it pops up with this error box, because the source file is not available. Even if the Wifi reconnects, Excel apparently "pauses" and will not refresh until I dismiss the error box:

Here's two possible ways I thought of that perhaps can workaround this issue:

  • A program that detects when the Source file is no longer available, and once it becomes available again, closes and reopens the local Dashboard file
  • A standalone Excel query/file viewer program that will not grind to halt if the Source file is unavailable, but will just silently and patiently wait for the file to become available again

Thanks in advance for any suggestions!

Pages: [1]