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

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,340
    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
    13
    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,340
    Articles
    0
    Excel Version
    Office 365 Subscription
    Glad you got there in the end.
    Ali
    Enthusiastic self-taught user of MS Excel!

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
  •