Share via

Excel 'Not enough system resources to display completely', Semi Annual Channel

Anonymous
2020-10-09T17:21:53+00:00

Various documents in our environment are triggering 1 of 2 error messages related to memory/heavy application use that were not an issue until the most recent version update. Error messages are triggered often times when simple Excel tasks are being completed, such as updating cells when two workbooks open, or simply trying to change the view on the workbook sheets from Normal to Page Break Preview and vice-versa.

We were previously on version 1908 and have been dealing with this issue on and off ever since the Semi Annual Channel jumped to version 2002 back in July 2020.

Error messages are:

Not enough system resources to display completely

Microsoft Excel is waiting for another application to complete an OLE action

Once these error messages appear, Excel eventually freezes/crashes/re-launches. It also appears that Excel is constantly calling 'Print driver host for applications' as this process is displayed under Excel in the Task Manager whenever one of the problem documents is opened. If you kill the 'Print driver host for applications' process in Task Manager, Excel functionality is not restored.

This also impacts the endpoint itself, as it becomes sluggish and icons/windows on the taskbar and desktop start experiencing some display issues (duplicate icons on taskbar, blank or improperly displayed areas on otherwise normal File Explorer windows from what appears to be a stuck prompt from Excel awaiting input, but it never loads/remains blank, etc.). Excel has to be forced closed in order for the endpoint to start behaving normally again, but often times it will require a full restart in order to return to normal functions.

Here's what we've tried in order to address the issue with no success on Office version 2002:

-Repair Office

-Remove and re-install Office

-Change default printer from network printer to Microsoft XPS/Adobe PDF

-Test on an endpoint without any printer queues/print drivers installed (except those provided by Microsoft/Adobe)

-Enabled 'Ignore other applications that use Dynamic Data Exchange (DDE)

-Enabled 'Disable hardware graphics acceleration'

-Disabled/removed all add-ins in Excel

-Tried launching Excel in safe mode and the files still trigger the same type of messages

-Moving files from network drives locally-- issue is present whether the file is on a network drive or saved locally

This is an issue across devices and OS, as we use Surface and Lenovo devices and are currently upgrading from Win10 1803 to Win 1903.

We've been rolling back affected users to version 1908 as a temporary workaround since this issue is not present on this version.

Is there a possibility that this is an unreported issue in version 2002 due to the introduction of new features from 1908? We've also been testing different channels (Monthly, Current) and it also does not appear to be an issue in those newer versions (2007, 2008, 2009).

Looking to see if any others have experienced similar issues. Again, downgrading (or upgrading) has been a workaround, but we're looking for a solution that does not require changing the update channel for the entire environment considering our size.

Can provide some log information but most has not been fruitful. However, there's been a couple of error reports in event viewer that have provided some information that perhaps may be helpful:

Error - Application Error: Faulting module path: C:\Program Files\Common Files\Microsoft Shared\Office16\mso40uiwin32client.dll

Error - Application Hang: Hang type: Top level window is idle

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Anonymous
    2020-10-09T21:08:34+00:00

    Hi,

    I’m glad to offer some help.

    Per your description, it seems that the Excel workbook will get the “Not enough system resources to display completely” error when doing some simple tasks like updating cells or making the changes and so on in the newer version 2002 for Semi Annual Channel. Besides, for version 1908 which as a workaround works fine, even other channels (like Current) also have no problem with the newer versions (2007,2008,2009.)

    May I confirm this is your scenario? Generally, when I open an Excel workbook in Semi Annual Channel version 2002 and make some changes on it, there won’t jump with the error. Given your situation, we are sorry for the inconvenience caused, but I will try my best to help you.

    Considering you have tried repair, re-install, safe mode and other troubleshooting steps, the issue still persists, to isolate whether this relates to your old account, if you are willing, you may try a new user profile to check it again.

    Meanwhile, also try to perform a clean boot in Windows to determine whether a background program is interfering with Office program.

    In addition, do other applications (including Word) also have the same issues?

    Whether all files or just the specific two workbooks get the behavior? How about a new workbook?

    We highly appreciate your cooperation to have a test and share the above information with us.

    Best regards,

    Gloria

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2020-10-12T15:05:43+00:00

    Hi,

    I'm writing this thread for monitoring, if you still need other assistance, please feel free to post back at your convenience.

    Have a nice day!😊

    Best regards,

    Gloria

    0 comments No comments