• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel ran out of resources

Welcome to the forum,

You haven't told us very much about what was going on. I would take the error at face value for the moment and try to free up resources. Close other applications/workbooks to start. Next, take a look at your worksheet/formula layout. Do you have a lot of volatile functions (like TODAY, OFFSET, INDIRECT) that are slowing things down? How many cells are you trying to calculate at once?
 
Thank you for your response and feedback, Luke.

I found the remedy. I had prepared a report which had data year to date with all the formulas. I have removed all the formulas and now not getting that error.
 
Back
Top