Forum Discussion
Solved
Stock data updating as file opens
Something has changed in Excel for me. When I open a file that has stock data in it, it is updating the stock data immediately. It used to be I would open the file and then update the data. I need...
That helped. I guess they added that feature recently.
I wish they had set it to manual by default since that was basically the default before they added the feature.
It is also interesting that is only in the right click menu on the stock data and not in the data section of the ribbon.
BTW I am only in Win10
This menu is from right click on icon since it depends on which data type you use. One settings for Stocks, another settings for Organizational and you have no options for, for example, Geography.
Other words, there are no common settings for all data types.
