+ Reply to Thread
Results 1 to 3 of 3

Web Query suddenly not working

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    Rapid City
    MS-Off Ver
    Standard 2016
    Posts
    13

    Unhappy Web Query suddenly not working

    I am using Excel 2016 and I have a web query that pulls data from a web-based project management system. Literally up until yesterday, it was working great.

    The way the web query is set up is that I paste the URL of a report that is generated in our system into the Edit Web Query popup and that directs me, initially, to the splash login page for our system. I log in, and then it takes me to the report. I then click the box next to the table I am importing. Click import, and done. Works great. Our system does have a 30 minute timeout, so I have the query refreshing every 5 minutes so that I have realtime data and it doesn't time out.

    For some reason, yesterday suddenly I started receiving the "Query returned to data" error. I check the web query and now it doesn't seem to keep me logged in to our web-based system. I bring up the Edit Web Query popup and every time, it only goes to the splash page. I log in, select the table, click import. Instant error. It's as if it isn't saving the cookie, or something. There is no permanence to my login anymore.

    I don't believe I changed anything. Has there been some sort of security policy update? Am I out of luck? Please help! This spreadsheet is my life!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Web Query suddenly not working

    Probably your local cookie expired or some policy change took effect on web site end.

    Try first checking with your vendor for the site. They may have API method to connect to the data (which would be more robust). You can connect to API through PowerQuery tool (Get & Transform -> From Web. Then pick Advanced).

    As far as I'm aware, there hasn't been any such update on Excel's end.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-23-2019
    Location
    Rapid City
    MS-Off Ver
    Standard 2016
    Posts
    13

    Re: Web Query suddenly not working

    I saved the workbook as Macro Enabled. That worked, then it didn't, then it suddenly started working again. I think it's me. I'm cursed.

+ 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. Macro Suddenly Not working
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2015, 08:19 PM
  2. Macros not working suddenly
    By JohnDoh in forum Excel General
    Replies: 0
    Last Post: 02-04-2015, 05:58 PM
  3. Optionbutton value suddenly not working
    By olle3770 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2014, 04:42 AM
  4. Workbook_BeforeClose is not working suddenly
    By Nitzan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2012, 02:25 AM
  5. VBA code suddenly not working
    By nermal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2012, 12:59 PM
  6. Replace Add-In suddenly not working
    By cheaperThanAPro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2007, 01:47 PM
  7. [SOLVED] Sumproduct suddenly not working
    By Andy in forum Excel General
    Replies: 7
    Last Post: 07-11-2005, 06:05 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