question

KyleMoody-3398 avatar image
2 Votes"
KyleMoody-3398 asked KismatCheema-7025 answered

Excel not opening properly after Intune rollout

Hi,

I have been experiencing an issue recently where I open Excel and I can see the process start in Task Manager (with about 30-40% CPU usage) however the application doesn't open. I have been able to get around it by performing a Quick Repair which fixes it briefly however the issue reoccurs.

We recently rolled out Intune and it seems this may be the cause.

Is anyone able to shed any light on this? I have had issues with Outlook crashing and that was caused by Exploit Guard however I wanted to make it known before I go looking elsewhere.

Thanks.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KyleMoody-3398 avatar image
1 Vote"
KyleMoody-3398 answered KismatCheema-7025 edited

Thanks for the responses,

I believe it may be Exploit Guard again causing the issue. It only happens on Excel however that is where policies from Exploit Guard are assigned. In the XML change:

EnableExportAddressFilter = "false"
EnableExportAddressFilterPlus="false"

I haven't heard back from the user yet so hopefully that fixes the issue. I will keep you posted if there is any development.

Update: This was not the case, user is facing the same issues this morning but after a reboot.

FROM A REDDIT POST

"Hi All. We have found out the issue here. It is the Security Baseline, specifically the XML configuration in Exploit Guard. Edit the XML to remove EnableRopSimExec="true" from EXCEL.EXE.

If you have impacted users, if you have admin rights on the Intune machine you can do this via the GUI:

Start > Windows Security > App & browser control left-hand option > Exploit protection settings > Program settings > search for Excel.exe > Edit > and TURN OFF "Simulate execution (SimExec)"

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Just wanted to say nice one for posting the solution from Reddit Kyle. I had few users with this Excel issue and after updating the Security Baseline's Exploit Guard XML it seems to have sorted them.

1 Vote 1 ·
TarquinM-4146 avatar image
0 Votes"
TarquinM-4146 answered TarquinM-4146 published

Not a fan of me tooing but we are having the exact same issue across multiple intune tenants - the only commonality being Intune itself.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TarquinM-4146 avatar image
0 Votes"
TarquinM-4146 answered

We removed Intune from one of our, now many, affected devices - this has resolved the issue until we can identify the exact cause. We havent adjusted policies in weeks within Intune which signals a concern that something on Microsoft's end has gone wrong. It would, as always, be great to hear from them on this matter but I won't hold my breath.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

erinding-msft avatar image
0 Votes"
erinding-msft answered

anonymous userMoody-3398

Does this issue occur on other Office applications like Word?

Please try to open Excel in safe mode eliminate interference from add-ins and startup items.
Press Win+R, type excel /safe, Enter.

If you can open Excel successfully in safe mode:
- Move the files in C:\Users\<User Name>\AppData\Roaming\Microsoft\Excel\XLSTART to other location temporarily, then check if the issue still exists.
- If it doesn't work, go to File>Options>Add-Ins. Towards the bottom of the window, where it says Manage, click the Go button. In the dialog box, uncheck the add-ins to disable them.


We recently rolled out Intune and it seems this may be the cause.

<< Do you mean that you enrolled your device in Intune to manage?
If yes, please add the Enterprise Context column to the Details tab of the Task Manager.

You could also try to un-enroll your device from Intune to check the issue.

Besides, to better help you, it is recommended to add a tag related to Intune like “mem-intune-enrollment”.

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinBond-7823 avatar image
0 Votes"
MartinBond-7823 answered MartinBond-7823 commented

The fix provided above worked for us, however some users are experiencing issues when using formula's =SUM(A1:A7) and excel crashes.

unsure if its related, however EventID shows

Log Name: Application
Source: Application Error
Date: 12/10/2020 10:19:54 AM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xxx
Description:
Faulting application name: EXCEL.EXE, version: 16.0.13127.20910, time stamp: 0x5fcbbcd1
Faulting module name: PayloadRestrictions.dll, version: 10.0.19041.1, time stamp: 0xe257489f
Exception code: 0xc0000409
Fault offset: 0x0006e6d6
Faulting process id: 0x232c
Faulting application start time: 0x01d6ce81bba7b4d8
Faulting application path: C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\WINDOWS\SYSTEM32\PayloadRestrictions.dll
Report Id: 2656bb9d-2038-4f3b-8a33-dec13b73cb3a

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

There was one further thing that was causing us issues, when users tried to use a filter on a spreadsheet it would also then too. Found out that the setting causing this was Validate API Invocation, and I tested it by setting it to off. I amended the xml in the baseline so that the line under Excel read EnableRopCallerCheck="false", in the same way as above.

I've just had a check and using a formula doesn't cause Excel to crash so hopefully this will work for you too...

1 Vote 1 ·

Thanks this works! Users are not experiencing issues with formulas in excel.

I made the change to the MDM Baseline, hopefully Microsoft comes back with an answer, would like to have both settings enabled back to default when a proper fix comes out.

1 Vote 1 ·
erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft commented

anonymous userMoody-3398

Thanks for sharing the workaround.

According to your description, I invite my Intune colleague to help me do the test, but could not reproduce this issue.
Our test environment is as below screenshots:
49387-microsoftteams-image-8.png
49427-microsoftteams-image-9.png
49491-capture.png
49428-microsoftteams-image-10.png
The configuration information in Intune are all default.

In order to check if we could totally reproduce this issue.
We may need more information of your environment:

  • Windows version

  • Office version

  • Configuration information in Intune

If you have any updates, please post back and we will do more test for you.

Thanks for your understanding.


If an Answer is helpful, please click "Accept Answer" and upvote it.
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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anonymous userMoody-3398

How is your issue going?
Any updates, please let me know.

0 Votes 0 ·
KyleMoody-3398 avatar image
0 Votes"
KyleMoody-3398 answered

Hi,

We solved the issue by using the above workaround from the Reddit post. I have checked your settings and they all seem fine however it is more the Exploit Guard that needs to be looked into. We are happy to continue without it until a time when it is fixed.

Kyle

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KismatCheema-7025 avatar image
0 Votes"
KismatCheema-7025 answered

Hi all

Just to add some more info on this for anybody who is interested or still having issues, you might have noticed that Exploit Guard settings are no longer pushed out via the baselines as they have been removed since the December 2020 ones were published. This in itself of course won't removed any of the settings affecting Office, however it seems that any of the entries added are being removed through Office updates so if anybody is having ongoing problems hopefully updating your baseline to the latest version and updating Office will sort this out.

If you can't update for whatever reason, a Quick Repair via the Add\Remove Programs Control Panel applet (or search the Start Menu for Add or Remove Programs) should sort things :)

For reference, Exploit Guard settings can be configured in Intune via Endpoint security>Attack surface reduction and creating a new Exploit Protection policy.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.