Separate names with a comma.
Discussion in 'Troubleshooting' started by LynxPtnr, Sep 13, 2017.
"Refresh All" button had been working fine since the fix of update 188.8.131.52, but today not working
I tried the 5 min Refresh Button, and that seems to be working
Hi, we did not change anything there, it should be working fine. Let me know if it still does not. Thank You
"Refresh All" working for Indexes but not LastPriceRealTime again this morning
Ok, hats strange. I am checking it. Thanks for notifying.
Did you ever figure out if there is a problem? "Refresh All" still not working for me
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.
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.
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!
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.
I'll try your suggestion tomorrow...
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.
Ok, thanks a lot for this analysis. Let me look into this today. And come back with an update tomorrow.
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?
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...
"Refresh All" still not updating stock prices
Have "5 mins refresh" box checked since my last post, and the only updates are on the Indexes, no updates to stock prices
At 10:05 am Eastern time, 35 minutes after the market opened, the "5 Mins Refresh" started refreshing prices
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
Please can we have a quick call or screenshare?
Let me know.