Forum Discussion

Brass Contributor

Nov 02, 2021

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, ...

excel

Stephen_Howell

Copper Contributor

Jan 29, 2023

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.

Andrewl3895

Copper Contributor

Feb 15, 2023

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.

wswift
Copper Contributor
Feb 15, 2023
Andrewl3895 I am having the same issues. Any idea how to fix ? or is this a Microsoft issue
- D0001
  Brass Contributor
  Feb 15, 2023
  What version of macOS and what version of Excel 365 are you running? wswift
  - Andrewl3895
    Copper Contributor
    Feb 15, 2023
    Windows 10Pro with 16G ram user with MS365 Excel v2301. Yes I'm doing an update now, will update in a bit.