Page 3 of 3 FirstFirst 1 2 3
Results 21 to 30 of 30

Thread: The Web Query Table data in excel not the same as displayed online at the website.

  1. #21
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,369
    Articles
    0
    Excel Version
    Office 365 Subscription


    Register for a FREE account, and/
    or Log in to avoid these ads!

    1. I opened your OneForAll file.
    2. I went to the Data ribbon and clicked on Refresh All.
    3. I compared the results - there is no difference, and they all match the current values on the website.

    Sorry, but YOU must be doing something incorrectly. I cannot replicate your problem and I cannot, therefore, help. You need to work out what it is that you are not doing correctly. There is nothing wrong with your queries.
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  2. #22
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    17
    Articles
    0
    Excel Version
    2016
    Thanks for all your efforts. I don't know what wrong. After I my last posted to you, I reduced the number of queries per workbook (28 to 11 & less) and disable background refresh. Now they always refresh & update (faster) and the data match what's on BURSA WEB each time. I guess my problem is now resolved. Case close.

  3. #23
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,369
    Articles
    0
    Excel Version
    Office 365 Subscription
    Glad you got there in the end.
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #24
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    17
    Articles
    0
    Excel Version
    2016
    Hi AliGW,
    When doing REFRESH, there are instances the data is not UPDATE with NEW data. Can you advise?

  5. #25
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,369
    Articles
    0
    Excel Version
    Office 365 Subscription
    Nope - I cannot replicate your problems, as I made clear before. Sorry.
    Ali
    Enthusiastic self-taught user of MS Excel!

  6. #26
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    17
    Articles
    0
    Excel Version
    2016
    Please take a look at the 2 attach files. One is a copy & paste from BURSA website. The other a REFRESH web-query where the data is not UPDATE.
    Attached Files Attached Files

  7. #27
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,369
    Articles
    0
    Excel Version
    Office 365 Subscription
    The query is refreshing just fine here.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #28
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    17
    Articles
    0
    Excel Version
    2016
    Hi, the EOD2 refreshed Vol('00) data (hilight in yellow) is not the same as the data (hilight in yellow) which I copy & paste from the BURSA website to show that PQ refresh did not UPDATE the data in EOD2. The copy & paste data was @ 6 a.m. the EOD2 refresh was done @ 6.24 a.m.

    My point is the hilight data to the 2 files (attached) don't match. i.e. EOD2 refresh did not UPDATE the Vol('00) data to what should be in the Bursa6am file. That's why I am telling that the PQ refresh is not updating (with new data) in EOD2. The 2 attached files is to show you - which you say you cannot replicate.
    Last edited by guanstan; 2020-02-07 at 09:53 AM.

  9. #29
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,369
    Articles
    0
    Excel Version
    Office 365 Subscription
    I say I cannot replicate it because I cannot replicate it - everything is refreshing as it should for me using your workbooks. What you are seeing is not what I am seeing. I am not sure what more you expect me to say - if your queries are refreshing properly for me and not for you, then it stands to reason that it is something at your end - something on your system - that is causing the issue. I cannot possibly know what that is - I have no way of diagnosing it. I have now, over three times, shown that it is not your workbooks or queries that are at fault - that is all I can do. It doesn't matter how many new versions of this file you share here, the result will be the same, so I have done all I can and will now bow out of the conversation. I hope you find what is causing this problem on your system.
    Ali
    Enthusiastic self-taught user of MS Excel!

  10. #30
    Seeker guanstan's Avatar
    Join Date
    Dec 2019
    Posts
    17
    Articles
    0
    Excel Version
    2016
    Thanks for you explanation and help thus far. Appreciate it.

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •