+ Reply to Thread
Results 1 to 8 of 8

table refresh manually but not by query anymore ??

  1. #1
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    table refresh manually but not by query anymore ??

    hi strange thing happend
    I have a table that is updating every 15 min and this already many months. yesterday suddenly it did not update anymore. If I right click and refresh manually it show the correct data, if i use the vba code in the macro, it put back old figures from yesterday ???
    example LOOM-BTC is now around 487 yesterday 555

    how this comes ????
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,536

    Re: table refresh manually but not by query anymore ??

    Have you changed the name of the workbook?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    Re: table refresh manually but not by query anymore ??

    hi, no, didn't change anything, happend suddenly ..
    I change the name now in this example, but it doesn't change the situation

    thanks

  4. #4
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    Re: table refresh manually but not by query anymore ??

    nobody can help ? someone let me know they tried on the file and have the same issue ? I rebuild the whole app, all new, and he still does it

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

    Re: table refresh manually but not by query anymore ??

    Patience. You only posted the question today...

    Well, you have...
    Please Login or Register  to view this content.
    In your "Module 11". But that's not being used anywhere else in your project.

    But you don't need to set refresh in code. Just change Query property->Usage->Refresh control.

    Neither of your query has data refresh interval set.

    I've tested it by setting Query1 to refresh every 5 min, and checked. Query updated fine without manual refresh.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  6. #6
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    Re: table refresh manually but not by query anymore ??

    Hi, Thank you for your help. The total file is a lot more bigger with different sheets and macros and tables, I only cut out the piece that makes the problem.
    also the 15 min run is an activation of procedures and macro runs, not only refresh this table.

    meanwhile i test some more, and seems like this problem only happens on my computer and only with this file. if I open it elsewhere it do it's job correctly. The new app in excel .... all new, but ut is the kucoin connection.
    The problem happend when my excel caused a blue screen crash on my computer. somehow somewhere the result of this connection is in my computer and every time restored. So I need to find out how I can remove the restore file for this connection table .. I think .... anybody can help ?
    Thanks

  7. #7
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    Re: table refresh manually but not by query anymore ??

    hi, I found the solution finally myself, so gone share it here for others. seems like something was stuck, I went to data get data query options clear cash ... and this did it

    have a nice day

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,536

    Re: table refresh manually but not by query anymore ??

    Thanks for letting us know.

+ 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. Excel not cannot refresh Sharepoint list anymore???
    By demon8991 in forum Excel General
    Replies: 1
    Last Post: 06-01-2014, 10:54 PM
  2. Refresh query from text source without manually selecting text file each time
    By ALN1991 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2013, 01:13 PM
  3. Refresh Query Table with VBA
    By fieldmarshamj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2013, 07:56 PM
  4. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  5. pivot table refresh when changing SQL query
    By davidmac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2007, 06:32 AM
  6. refresh Query table using own password for each username
    By kuh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2006, 01:35 AM
  7. ideas - Query table refresh
    By MattShoreson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2005, 07:05 AM

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