Promlem with ran out resources when canculation in excel

Hello @Le Thanh Quyen

It’s wonderful news that the issue has been resolved, thank you for letting us know!

I believe many users may encounter a similar issue, and your case could serve as a valuable reference for them. That’s why I’d like to summarize this post so other forum members can easily find helpful information here:

=========================== 

Issue Description: Excel displayed a “ran out of resources” error during a simple calculation, even with a small table (10 columns × 10 rows) and basic formulas. The issue persisted across new files and remained unresolved despite switching to manual calculation and contacting Microsoft support.

Troubleshooting Steps Taken: The user performed extensive troubleshooting, including:

• Verifying formula references to avoid full-column calculations
• Starting Excel in Safe Mode to rule out add-in conflicts
• Repairing the Office installation (Quick Repair and Online Repair)
• Updating Office and Windows to the latest versions
• Creating a new Windows user profile to test for profile-specific issues
• Completely uninstalling and reinstalling Office using the Microsoft Support and Recovery Assistant (SaRA) tool

Final Resolution: Despite all efforts, the issue persisted until the user reinstalled Windows. After the reinstallation, Excel functioned normally, indicating that the root cause may have been tied to deeper system-level corruption or misconfiguration.

=========================== 

To help others in the community benefit from this discussion, please consider clicking “Accept Answer”. Doing so will pin the thread to the top, making it easier for others to find when searching with related keywords. It also helps highlight the discussion for users who might benefit from it, while keeping the thread open for further contributions.

Your action could help many others in the community find the right solution faster. Thank you again for your time and for contributing!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Dear @Le Thanh Quyen

Thank you for posting your question in the Microsoft Q&A forum. 

Before we begin troubleshooting, could you please confirm whether you're using a personal Microsoft account (e.g., @hotmail.com or @outlook.com) or a work/school account (e.g., ******@yourcompany.com)? 

This helps us determine the appropriate support path, as some solutions may vary depending on the account type. 

In the meantime, we’d like to guide you through a few steps to help resolve it. 

Step 1: Verify Formula References 

Could you please help double-check the formulas you're using in your Excel file? Sometimes, referencing entire columns can cause resource errors, even in simple calculations. 

For example: 

• Incorrect (can cause resource errors): =A:A + B:B 
• Correct: =A1 + B1 (then copied down) or =SUM(A1:A10) 

If possible, could you please share a screenshot of the formula you're using? Before sending, please make sure to remove or blur any personal information (PII). 

If your formulas are correct, please proceed to the next step. 

Step 2: Start Excel in Safe Mode 

This is the most important diagnostic step. Safe Mode starts Excel without loading any add-ins. If the error disappears in Safe Mode, it confirms an add-in is causing the problem. 

• Press and hold the Ctrl key on your keyboard. 
• While holding Ctrl, double-click the Excel application icon. 
• Keep holding Ctrl until you see a dialog box asking if you want to start Excel in Safe Mode. Click Yes. 

Once Excel is in Safe Mode, create a new file or open your simple file and test the calculation again. 

• If the problem is gone in Safe Mode: You need to disable your add-ins one by one to find the culprit. You can manage them under File > Options > Add-ins. 
• If the problem persists in Safe Mode: Continue to the next step. 

For more details, see this Microsoft article: Open Office apps in safe mode on a Windows PC 

Step 3: Repair Your Office Installation 

Your Excel application files may be corrupted. An Online Repair can fix this by reinstalling the necessary files without affecting your data: 

• Right-click the Start button (lower-left corner) and select Installed apps from the menu. 

• Find Microsoft 365 or the Office product (Excel) you want to repair. 
• Click the three dots (ellipses) next to it and select Modify. 

You will see two options: 

• Quick Repair: This runs quickly and fixes most common issues. Try this first. 
• Online Repair: This is a more thorough repair that requires an internet connection. It essentially re-downloads parts of the installation. If Quick Repair doesn't work, use this option. 

Follow the on-screen instructions to complete the repair process. After it's done, restart your computer and try opening Word or Excel again. 

Here is the reference: Repair an Office application - Microsoft Support 

Step 4: Update Office and Windows 

Finally, ensure you are running the latest versions to rule out any known bugs. 

• For Office: In Excel, go to File > Account > Update Options > Update Now. 

• For Windows: Go to Settings > Windows Update >Check for updates.

Please try the steps above, and if possible, kindly update me on the outcome of each step whether the issue was resolved or if it persists. Also, please confirm the type of account you're using (personal or business), so I can better assist you or raise the issue to the appropriate team if needed. 

Looking forward to your update. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.