Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
Can someone please help me with my below post/question?
Thanks
Don
Don_Thornton replied to Sangeeta Mudnal
Jun 24 2024 08:07 PM
Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton
Thanks
Don
Don_Thornton replied to Sangeeta Mudnal
Jun 24 2024 08:07 PM
Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton