To Anyone Who Can Assist
Please refer to attachment.
Why am I receiving the error message that is shown in attachment, and how can I fix it, please?
I can attach a working spreadsheet at a later date - once confirmed that someone can assist me - to protect my privacy and any details contained within spreadsheet.
Thank you.
resources.JPG
Last edited by 6StringJazzer; 10-03-2021 at 10:03 PM.
Your title does not tell us enough about your question. Please review our rules, most importantly rule #1.
When you want to show an image, please attach the image directly in your post rather than putting it in a Word file and attaching a file. Click Go Advanced, then click the image icon to select an image file for posting.
I have corrected your post to reflect these two.
It will probably not be possible to diagnose this without being able to see all the formulas in your file.
Last edited by 6StringJazzer; 10-03-2021 at 10:06 PM.
Hello,
"Excel ran out of resources ..." is typical to calculations using a very large (hundred of thousands) number of rows, even though most are empty or useless, or ranges without rows being specified.
There are tools out there if you want to find those formulas in the spreadsheet, if there is a ton of formulas in it and you don't know where to start or don't have the time to scan each cell.
Hi there - I am getting the same problem. What kind of tools are those that can help you find faulty formulas?
Administrative Note:Originally Posted by Marytaii
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, it is not directly related to the original question.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
The style reduction tool has been diagnosing "Excel ran out of ressources..." and fixing it for at least a year.
Take a look at the "slow calculations" indicator.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks