Forum Discussion
Solved
Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."
I am having issue with excel sheet which keeps showing me this issue "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas can not be evaluated."...
In cell D36 you have formula =30:294001 which means you instruct Excel to return all rows from 30 to 294001. Includes row in which the formula is. Kind of cyclic reference and never ended loop.
If you remove this formula it works.
SergeiBaklan All of my spreadsheets show this error and I am not using formulas. This issue just began for me. I have my cells marked as "General" as input type and every time I delete, tab over, press enter, etc. the error pops up. I am simply trying to keep a list of attendees for an event with some details (emails, arrival dates, etc.). Any tips/settings? Thanks!
SergeiBaklan Similar to other ppl on this thread, I have spent hours trying to find the issue with the same error that other people had, and the Excel is extremely slow. Would you be able to have a look?
I'll try if you share the file
- Awesome. Would love to share the file. How do I share the file?
- Nevermind. I'll private message you. Thanks!