Here is my workaround. It seems to work but folks here can weigh and tell me if I've gone off track.
I created a Google Sheets doc called My Stock Prices.
Column A is the ticker i.e. SPY, AAPL, MSFT. This column should be in the same order that you have in your Excel doc. Don't copy/paste from Excel, just retype the tickers.
Column B is =GOOGLEFINANCE(A1, "price")... drag down to copy formula for each stock ticker.
File > Setting > Calculation > Recalculation = On Change
File > Share > Publish to web > make sure that automatically republish when changes are made is checked > Publish > copy URL
In Excel create a new tab (I named the tab "Google Sheet").
In that new, blank tab Data > Get Data > From Other Sources > From Web > paste URL
Data from Google Sheets gets pulled in. I created a new, separate tab for this because I don't know how to just pull a cell from Google Sheets (or if that's even possible) so I just pulled in the whole sheet to a new tab and then did the next step below.
In the original Excel tab's cell, replace the non-working query (i.e. =A1.Price) that was pulling in stock prices from the MS server with ='Google Sheet'!B2 (it's B2 instead of B1 because it imported a header that I didn't bother to delete. Now instead of the closing price from 12/31/25 for SPY, AAPL, MSFT etc it should pull in the closing price from 1/2/26.
Data > Queries & Connections > dialog box pops up on right side of screen > right click on the query > Properties > click on Refresh every xx minutes (change to however frequently you want it to update) > click on Refresh data when opening the file > OK
Important! Google Sheet must be open for it to update so just leave it open while market is open and stock prices are changing for intraday updates. The values in the cell with the price should start updating when the market opens 1/5/26.
That's it. Hope this works. I guess I'll find out 1/5/26.
NS