Forum Discussion
D0001
Nov 02, 2021Brass Contributor
Excel 365 Stock Data not updating all stocks
Does anyone know how to determine which stocks are now updating and which are not (without doing a laborious manual compare to another source)...is there a list by Refinitiv perhaps? Alternatively, ...
Stephen_Howell
Jan 29, 2023Copper Contributor
From the Menu bar select Formulas then choose Error Checking. Then choose Error Checking again. This should advance you to the cell where there is an error. The dialog panel that opens will tell you what the error is, in this case Unable to refresh data type. You can then choose it Ignore Error or Edit in Formula Bar. Click Next or Previous to move to the next error. That is the best way to find these slightly mysterious errors.
- Andrewl3895Feb 15, 2023Copper Contributor
Is anyone having issues (since yesterday) of stockhistory not reporting recent results?
I've used this for months and all of a sudden no data is available after 2/10/23.
thanks.
- wswiftFeb 15, 2023Copper Contributor
Andrewl3895 I am having the same issues. Any idea how to fix ? or is this a Microsoft issue