Stock data updating as file opens

Thanks -- I also found that video helpful as I had the same problem as the OP.

Until recently, refreshing stock quote data in Excel was under my control, but lately it changed to occurring automatically after the workbook is opened. What's worse is that, unlike manual data refreshes ("Refresh All" in the Data ribbon), I can't undo (CTRL-Z) the automatically refreshed data to restore the data from the earlier time.

Anyway for those who aren't able to watch the video (I previously worked somewhere that blocked YouTube), here's how to disable the automatic refresh for the stock data type:

1. Right-click the stock data type icon in any stock data type cell. (I'm referring to the icon that looks like the front of the NYSE stock exchange.)

2. In the context menu that appears, choose "Data Type", followed by "Refresh Settings" from the sub-menu that appears.

3. In the Data Types Refresh Settings panel that opens, click "Stocks" to expand.

4. Under "Refresh this data type", click "Manually". You can close the Data Types Refresh Settings panel.

5. Save your workbook.

Finally, I wondered if that change applied only to the one cell -- it doesn't. Rather, it applies to the entire stock data type for the workbook, so it doesn't matter which icon you right-click to access the Data Types Refresh Settings panel.