STOCKHISTORY function -- File not responding

%3CLINGO-SUB%20id%3D%22lingo-sub-2022011%22%20slang%3D%22en-US%22%3ESTOCKHISTORY%20function%20--%20File%20not%20responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022011%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20an%20Excel%20spreadsheet%20using%20the%20Stockhistory%20function.%20To%20download%20daily%20price%20data%20for%20multiple%20stocks%2C%20I%20have%20used%20in%20one%20of%20my%20files%3A%20%3DTRANSPOSE(STOCKHISTORY(%24B%2432%2CTODAY()-42%2CTODAY()%2C0%2C1)).%20Unfortunately%2C%20I'm%20getting%20a%20SPILL%20error%2C%20probably%20because%20of%20the%20%2242%22%20setting.%20This%20results%20in%20Excel%20becoming%20unresponsive.%20To%20fix%20the%20problem%2C%20I'd%20like%20to%20delete%20that%20function.%20It%20looks%20like%20when%20I%20open%20the%20file%2C%20the%20data%20download%20automatically%20starts.%20Does%20anyone%20have%20a%20solution%20to%20my%20problem%3F%20It's%20a%20large%20file%2C%20so%20I'd%20like%20to%20avoid%20rebuilding%20the%20file%20from%20scratch.%20Is%20there%20a%20way%20to%20stop%20data%20download%20from%20starting%20automatically%20when%20the%20file%20is%20open%3F%20Would%20appreciate%20any%20suggestions%20to%20my%20problem.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2022064%22%20slang%3D%22en-US%22%3ERE%3A%20STOCKHISTORY%20function%20--%20File%20not%20responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022064%22%20slang%3D%22en-US%22%3Ebtw%2C%20I%20believe%20the%20unresponsiveness%20is%20due%20to%20Spill%20error%20because%20in%20bottom%20right%20I%20see%20%22Calculating%20(Spill%20Resize%20Pass%201)%3A%200%25%22%20and%20it%20stays%20here.%20Any%20attempt%20to%20navigate%20on%20the%20spreadsheet%20results%20in%20%22Excel%20(Not%20Reponding)%22%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, I have an Excel spreadsheet using the Stockhistory function. To download daily price data for multiple stocks, I have used in one of my files: =TRANSPOSE(STOCKHISTORY($B$32,TODAY()-42,TODAY(),0,1)). Unfortunately, I'm getting a SPILL error, probably because of the "42" setting. This results in Excel becoming unresponsive. To fix the problem, I'd like to delete that function. It looks like when I open the file, the data download automatically starts. Does anyone have a solution to my problem? It's a large file, so I'd like to avoid rebuilding the file from scratch. Is there a way to stop data download from starting automatically when the file is open? Would appreciate any suggestions to my problem. Thanks.

1 Reply
btw, I believe the unresponsiveness is due to Spill error because in bottom right I see "Calculating (Spill Resize Pass 1): 0%" and it stays here. Any attempt to navigate on the spreadsheet results in "Excel (Not Reponding)"