Issue
When customers encounter the error message "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated" it indicates that Excel is unable to process complex or numerous formulas due to resource limitations.
Step-by-Step Resolution
1. Use Fresh Templates
Advise customers to use fresh templates from the Business Fitness website. This step can resolve issues related to corrupted or overly complex templates*:
- Open a web browser.
- Go to workpapers.businessfitness.com.au.
- Sign in and download fresh templates.
- Use these templates for new workpapers
Coordinate with the firm's admin team if necessary to ensure that all users have access to the updated templates.
* If the customer is using a customized template and it is loaded with too many links, it could cause the "Excel ran out of resources" error. This issue has been observed in several instances, such as in ticket [#62829]
If using new fresh templates do not resolve the issue there are published external articles that could provide guidance;
and