Dec 30 2020
12:55 AM
- last edited on
Jun 17 2022
11:06 AM
by
TechCommunityAP
Dec 30 2020
12:55 AM
- last edited on
Jun 17 2022
11:06 AM
by
TechCommunityAP
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.
Dec 30 2020 01:09 AM