Since latest Excel release, a form on my Excel project reports an out of memory error

Question

Since latest Excel release, a form on my Excel project reports an out of memory error

Ray Young 0

I have an excel solution which uses approx. 10 sheets, a number of forms, classes etc. One of the forms will not open in development or user mode and reports an Out of Memory error since the latest release of Office 365 - Friday 18th August 2026.

Previous versions of the file also do not work so I know it is not a corrupt file.

I had a colleague try this on her computer which does not have the latest release of Excel and it works. I had her export the form and when I try to import it onto the project on my machine after deleting the original I get the following log error.

Line 2: Property OleObjectBlob in Calculator could not be set.

This project it very important and about to role out to users so this is quite urgent.

Can you please advise on a mechanism to resolve this issue.

0 comments

3 answers

Your answer

Answer 1

Hello @Ray Young

Thank you for the information provided.

Based on your description, I understand that the issue started occurring after updating to the latest version of Excel. At the same time, your colleague, who is using an earlier Office version and has not installed the latest update, is able to work with the same file without experiencing this issue.

To help determine whether the issue is related to the recent Office update, could you please follow the steps in the following Microsoft article to revert Office to an earlier version that matches your colleague's version? How to revert to an earlier version of Office - Microsoft Support

After reverting the Office version, please test the affected Excel file again and let us know whether the issue still occurs.

In addition, could you please provide the following information?

A screenshot of the complete error message, including the message stating "OleObjectBlob in Calculator could not be set."
Details about whether the workbook contains or uses VBA macros, forms, ActiveX controls, or any custom add-ins.
The Office version and build number currently installed on your device, as well as the version your colleague is using

Once you have completed the Office rollback and tested the file, please let me know the results. I look forward to hearing from you.

Answer 2

Ray Young 0

Hello

Thank you for coming back to me so quickly.

User's image

Here are the errors reported when I try to open the form in Developer mode (VBA) in Excel.

The Error "OleObjectBlob in Calculator could not be set." is from the log file when I remove the form and then try and import it from the working machine (older version)

This form uses activex controls and vba code. Here are the references used:-

User's image

The Office version with the problem is

User's image

My colleague ''s version where everything works is:-

User's image

I know you have asked to roll back to the previous version but this will not fix my problem as this solution will be rolled out to a number of users soon and they all have the most up to date versions of Office (Auto Update). To roll back everyone is just not feasible.

I look forward to your reply.

Thank you again.

Helen Luu 2,785 Reputation points Independent Advisor

2026-08-28T13:05:06.4233333+00:00
Hi Ray,

I found the following article that may be helpful in addressing the issue you are experiencing:

vba - Excel giving "System Error &H80004005 (-2147467259). Unspecified error" message - Stack Overf…

Note: This link is shared by community members for your convenience. It points to a third-party site that is not managed or verified by Microsoft. I can’t guarantee the quality, safety, or suitability of any content or software found there. Please review carefully and make sure you understand any potential risks before using it.

In addition, could you please help check the following items?

Verify Whether the Excel File Is Blocked

Right-click the affected Excel file and select Properties.

Under the General tab, look for an Unblock option.

If the Unblock button or checkbox is available, select it and click Apply.

Check for Missing VBA References

From the Workbook, press Alt + F11 to open the Visual Basic Editor.

Select Tools > References.

Review the list of references. If any reference is marked as MISSING, please uncheck it or replace it with the appropriate version available on your system.

Please help me to check those information above and let me know if you any results. I look forward to hearing from you.
Helen Luu 2,785 Reputation points Independent Advisor

2026-08-31T10:56:13.5266667+00:00

Hi,

I hope you're doing well.

Just wanted to check in and see if there are any updates regarding this. When you have a chance, I'd appreciate any information you can share.

Please feel free to let me know anytime. Thank you, and I look forward to hearing from you.
Ray Young 0 Reputation points

2026-08-31T13:10:38.1766667+00:00

Hello Helen

Apologies for the delay in replying.

I identified the object that was causing the issue, a rich edit box, which was not part of the inbuilt objects available within Excel VBA. As I could not open this, I have had to rebuilt the entire form without using the rich text box and it seems to work now.

Unfortunately reverting back to the previous version of Excel was not an option for me though it did confirm the problem was caused by this update to Excel.

Thank you for your comments
Helen Luu 2,785 Reputation points Independent Advisor

2026-09-01T15:29:16.9966667+00:00

Hi Ray,

Thank you for the update. I am glad to hear that you have found the reason why you have the issue with your Excel VBA.

I understand how the recent Excel update has caused this inconvenience and impacted your workflow. To help bring this matter to the attention of the product team, I strongly encourage you to submit your feedback directly through the Microsoft Feedback Portal. Microsoft's product and engineering teams actively review customer feedback, and many product improvements and enhancements are driven by suggestions and reports from customers. By sharing your experience, you can help the team better understand the impact of the recent changes and evaluate whether further improvements or fixes may be needed in a future update.

Thank you again for taking the time to share your findings. Please feel free to let me know if you have any additional questions or concerns. I will be happy to assist further.

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more