Excel ran out of resources while attempting to calculate one or more formulas

[All2Cheesy]

Hi all,

Apologies for the long post. I maintain a relatively large workbook (5.91mb) that's used by the sales team within the company I work in. The company has expanded, and as such, I've had to add in calculations to the workbook, and ever since, the sales team have been receiving the following error message:

Excel ran out of resources while attempting to calculate one or more formulas

I've done a bit of troubleshooting to try and resolve this error, including:
* Cleaning up the data and macros within the workbook
* Rebuilding the workbook from the ground up
* Consolidating and removing pages
* Set excel to manually use less processes
* Removed all conditional formatting
* Removed the newly added section (While the above changes were applied)

However, none of this has resolved the issue.
I've restored the previous version of the workbook (Which is roughly 1.5mb larger than the new workbook after the above changes) and the issue does not occur.

I'm at a loss here, are there any other ways to get around this issue?

Unfortunately, this workbook contains sensitive information and cannot be posted.

 

[hiker95]

Thanks for all the assistance guys.

All2Cheesy,

Thanks for the feedback.

You are welcome. Glad that you able to solve your own request.

And, come back anytime.

 

[All2Cheesy]

Haha, whoops. I meant Formula. It was a long day.