Forum Discussion

Rory_B's avatar
Rory_B
Copper Contributor
Aug 04, 2021
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...
excel
Toddfrey's avatar
Toddfrey
Copper Contributor
Jan 30, 2022
How do you get your old data back though? As soon as I open the 30/9/21 data goes before I can change it to manual update only.
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jan 30, 2022
I guess you could use STOCKHISTORY().
  • Toddfrey's avatar
    Toddfrey
    Copper Contributor
    Jan 30, 2022
    Thanks but there is me login in to do a ten second job and Microsoft are now making me rebuild five years of quarterly valuations. Do they consult on changes like this? So frustrating.
    • cwrea's avatar
      cwrea
      Copper Contributor
      Jan 30, 2022

      Toddfrey What if you were to go offline / airplane mode before opening your workbook? Excel can't update the prices if there's no Internet access.

      • Toddfrey's avatar
        Toddfrey
        Copper Contributor
        Jun 01, 2022

        Thanks that worked cwrea 

Resources