Forum Discussion
Excel stock data not updated
This is still happening as of Dec 23, 2022. I have to select every Stock ticker cell and press F2 to get the corresponding Price and other cells to update. The Prices etc. do not update automatically or by pressing F9. So, everything is manual.
As a subissue, most tickers do allow me to update at least with the F2 method. But when I press F2 in a ticker cell with the S&P 500 ticker (which Excel deems to be "S&P 500 INDEX"), I get the Data Selector sidebar with its recommended ticker options, which requires me to reenter "S&P 500 INDEX" into the cell every time. Other tickers do at least update with the simple F2 procedure.
I did give Feedback just now using the link in Data Selector, noting that the update issue has been on the Internet for years now. Whether it will do any good...