"Refresh All" button not working today

Discussion in 'Troubleshooting' started by LynxPtnr, Sep 13, 2017.

"Refresh All" button not working today

  1. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    "Refresh All" button had been working fine since the fix of update 8.0.0.6, but today not working
     
  2. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    I tried the 5 min Refresh Button, and that seems to be working
     
    marketxls likes this.
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi, we did not change anything there, it should be working fine. Let me know if it still does not. Thank You
     
  4. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    "Refresh All" working for Indexes but not LastPriceRealTime again this morning
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, hats strange. I am checking it. Thanks for notifying.
     
  6. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Did you ever figure out if there is a problem? "Refresh All" still not working for me
     
  7. purrybonker

    purrybonker Member

    Joined:
    Mar 21, 2016
    Messages:
    30
    Likes Received:
    1
    I've been noticing the same behaviour lately - "refresh all" frequently causes no updates to stock prices but always updates FX values.

    When I hit "refresh all", it shows the "calculating" message on the tool bar ("refresh all" on my spreadsheets runs for about 60-90 seconds to complete) but most times, there are no changes to stock quotes - just updates to FX values by the end of the refresh process.

    As mentioned, this seems to be a new issue since the last update.

    Also, sometimes "refresh all" works properly, other times not.
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, I will have a look. Its strange because we did not do anything on Refresh all in the last release.

    When you face this issue again, please can you test it to be completely sure? Like this...

    Copy and paste the formula results in a new sheet. And then Refresh all after 5-10 minutes. And then copy and paste the results again on a new sheet. Then compare the numbers to see if it is not changing.

    I tried the same, and looks to be fine. But I will keep an eye on it.

    Kind regards
    Ankur
     
  9. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Since I haven't been able to get "Refresh All" to update stock prices, I have been using the "5 mins refresh". This morning the "5 Mins Refresh" is not working either. Please help!
     
  10. purrybonker

    purrybonker Member

    Joined:
    Mar 21, 2016
    Messages:
    30
    Likes Received:
    1
    I generally don't use the "5 minute" refresh - but, coincidentally I did try it today and it did seem to work for me but, in fairness I was away from my spreadsheets for several hours so there were obviously lots of "refresh" attempts during that period.
     
  11. purrybonker

    purrybonker Member

    Joined:
    Mar 21, 2016
    Messages:
    30
    Likes Received:
    1
    I'll try your suggestion tomorrow...
     
  12. purrybonker

    purrybonker Member

    Joined:
    Mar 21, 2016
    Messages:
    30
    Likes Received:
    1
    Definitely a problem with both refresh all and 5 minute refresh today.

    This was my sample sequence to show the problem:

    1) "ABT" entered in cell A1.

    2) "=LastTrade_PriceOnly(A1) entered in cell A2 returning a value of $51.61.

    3) "5 Mins Refresh" box ticked. Two hours later (markets still open) A2 still shows $51.61.

    4) "Refresh All" initiated. A2 still shows $51.61.

    5) "=LastTrade_PriceOnly("abt") entered in cell A3 (after market close) returning a value of $51.43.

    6) "Refresh All" initiated.

    Cell A2 continues to show $51.61 for ABT while cell A3 shows $51.43 for ABT.

    Refreshing not happening today with either "refresh all" or "5 mins refresh".

    As I mentioned before, FX reliably update with both.
     
  13. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, thanks a lot for this analysis. Let me look into this today. And come back with an update tomorrow.

    Kind regards
    Ankur
     
  14. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Refresh All, did have a problem when we first released this version. May I ask, if you could please uninstall your existing version and install it again from the link which was sent to you in email?

    I am thinking may be you were the initial few ones who downloaded the immediately the version that had the Refresh All issue. Please can you try that and confirm back?

    Thanks
     
  15. purrybonker

    purrybonker Member

    Joined:
    Mar 21, 2016
    Messages:
    30
    Likes Received:
    1
    I downloaded and re-installed XLS today to be sure. Still not working.

    Looks like the data base behind quotes not even refreshing today. I have entered "=LastTrade_PriceOnly("abt")" every 10 minutes into a new cell and they all show $51.94. Actual price of ABT has fluctuated frequently during that period.

    Try it yourself...
     
  16. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    "Refresh All" still not updating stock prices
     
  17. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Have "5 mins refresh" box checked since my last post, and the only updates are on the Indexes, no updates to stock prices
     
  18. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    At 10:05 am Eastern time, 35 minutes after the market opened, the "5 Mins Refresh" started refreshing prices
     
  19. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Can I PLEASE get some help with this? Getting the "Refresh All" button to work would really take the strain the "5 min refresh" puts on my spreadsheet
     
  20. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi,

    Please can we have a quick call or screenshare?

    Let me know.

    Thanks
    Ankur
     

Share This Page