EPM "Edit Report" is grayed out

[former_member254404]

Hi Team,

One if users not able to run the report . Edit and Context options is disabled in the report . So reports is not able to run

We cleared all Temp file

In same machine if login with Administrator privilege , The reports is running fine

Can you please suggest any work around need done in User machine

Regards

Dayalan M

[former_member254404]

Hi ,

I deleted PC_NW folder form system

Then Re installated , Still issue is not solved

[former_member591106]

This message was moderated.

[former_member254404]

Hi

I Re installed the EPM addins in the user machine for more than 2 times

And also re install the Excel 2007 . Even excel 2007 also having same issue

One thing I noticed in the user machine . T

There is so many profiles having that user machine in C drive .May be so many profiles leads the problem

[Former Member]

Hi sriram,

Then try to delete PC_NW folder.

[former_member254404]

Hi

This issue only having 2 users alone

There Re installed the Excel 2010 32 bit SP 1 .

This Issue having after re installation the excel 2010 .

[Former Member]

Hi shriram,

This Issue having after re installation the excel 2010 .

Then try to re install EPM addin and latest version

[former_member254404]

Hi Bishwajit,

I checked the Windows update in the user machine .

But there is no windows update in the user machine as per sap notes

Security update for Microsoft excel 2010 ( KB2910902)  - Its not available in the user machine

Please suggest

[Former Member]

Hi

As per not only KB2910902 update. please check other updates also.

One or several of these Microsoft security updates have been installed on the client machines where the issues are reproduced:

¡ MS14-081: Security update for Microsoft Office 2010 (2899518)

¡ MS14-081: Security update for Microsoft Word 2010 (2899519)

¡ MS14-082: Security update for Microsoft Office 2007 (2596927)

¡ MS14-082: Security update for Microsoft Office 2010 (2553154)

¡ MS14-082: Security Update for Microsoft Office 2013 (2726958)

¡ MS14-083: Security update for Microsoft Excel 2007 (2984942)

¡ MS14-083: Security update for Microsoft Excel 2010 (2910902)

¡ MS14-083: Security update for Microsoft Excel 2013 (2910929)

l This issue appears to be an unintended side-effect of the security notes disabling ActiveX controls.

l The issue is not specific to SAP products and is potentially affecting any application using ActiveX controls.

Have you delete all ".EXD" file?

Microsoft has confirmed this issue in KB 3025036 and has also provided an automatic fix located at: Microsoft Fix it 51029

l The recommended solution as per Microsoft KB 3025036 is to delete all "MSForms.exd" files (the automatic fix 51029 documented in the

resolution for symptom 1 of KB 3025036 deletes these files automatically)

l To resolve the issue, delete the cached versions of the control type libraries (extender files / *.EXD) on the client computer.

l Search the computer file system for files that have the ".exd" file-name extension, and delete all the MSForms.exd files that you find. To do

this, follow these steps:

Delete any "MSForms.exd" files in any subfolder of the "C:\Users\[user.name]\AppData\Local\Temp\" folder.

Depending on the specific applications installed on your desktop you may find this file in a variety of sub-folders:

• C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd
• C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd
• C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd
• C:\Users\[user.name]\AppData\Local\Temp\2\Excel8.0\MSForms.exd

[Former Member]

Hi sriram,

1)     check that your report or input schedule is not protected.

2)     Check your security setup. user have access to "Edit Reports".

[former_member965688]

Hi All,

If you have tried deleting the .EXD files and the Office Update and still having the Edit Report grayed out. I did the following and it has worked on three Workbooks we were about to rebuild.

This worked on EPM add-in 10.0 SP 20 Patch 2 .NET 4. Build 9063.

* Save broken sheet as a different name to have backup copy to try this on.

1. Open the copy of the EPM Workbook where the Edit Report is grayed out.

2. Click on the EPM tab in Excel.

3. Go to Options (In the tools Sub Tab right hand side of EPM tab).

4. General -> Worksheet Type -> Change from EPM Worksheet to Excel Worksheet -> OK

5. Let the Worksheet come back and see the EPM Pane and Context are gone.

6. Then change the Worksheet back to an EPM Worksheet.

6.1. Go to Options.

6.2. General-> Worksheet Type -> Change from Excel Worksheet back to EPM Worksheet -> OK

Then you should see the Edit Report button come back.

This again worked for me after trying to Office Update and deleting the .EXD files and restarting Excel.

Best of luck to anyone facing this problem and hope maybe this worked for you too.

[bishwajit_das]

Hi Sriram,

Could be because of the security updates for MS EXCEL. So, refer to the below thread:-

Regards,

Bishwajit

[andrewdiaz2000]

Hi Sriram,

What version of EPM ADD in and office are you currently using?

If possible try to upgrade your version of EPM Addin to SP 18.

and check all windows updates are installed.

Hope it would solve your problem.

Regards,

Andrew.

[Former Member]

Have a look at SAP note 2107965

[Shrikant_Jadhav]

Hi Sriram,

Kindly check the task profile of that user whether the user has edit report task

Shrikant

[Former Member]

Dear:

Browse the windows updates specifically note, 0002107965.

regards

Carolina