Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2015, 04:29 AM
timshep timshep is offline Data Connection - auto logoff Windows 8 Data Connection - auto logoff Office 2013
Novice
Data Connection - auto logoff
 
Join Date: Aug 2015
Posts: 1
timshep is on a distinguished road
Default Data Connection - auto logoff


Using Excel 2013 on Windows 10
Using Data Connections within macros to restore a set of data from an external website. This requires a SendKeys to 'Refresh' the Query each time as there is a log in page on the site before getting to the table required.
Before today (yesterday also on same OS/Excel version) the site would stay logged in and therefore, when I did a refresh, the correct table entry came back.
However, today, after the initial enquiry refresh (where you used to be able to log on and timeout would stop log out) and then Refreshing the data connection, I am only being returned the 'data' from the sites 'log on' page, i.e. the site has auto logged out and needs to log on, but has data connection cannot 'pause' whilst logging in I cannot retrieve my data.
Reply With Quote
Reply

Tags
data connection, excel 2013, windows 10



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Connection - auto logoff Update data connection - path, database name, query definition jaworski_m Excel 1 08-03-2015 02:37 AM
Excel 2007 security alert - data connection message every time? michael.monaco Excel 0 12-20-2012 07:47 AM
Losing signature on reboot / logoff Scorgi Outlook 0 09-20-2012 03:00 AM
Auto Logoff for Outlook -- is it possible? pigpen Outlook 2 06-25-2011 02:21 PM
Data Connection - auto logoff auto data completion Albatross Word 1 02-11-2010 11:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft