Edit report, SaveData doesn't work in input-forms EPM with Macro on office 2016

[former_member381444]

We are in EPM 10nw(SP25).

After reinstalling windows 10 and install Microsoft Office 2016 we have the issue in excel input-form with macro:

'Edit Report' is grayed out

Context options are grayed out

The EPM pane shows no connection for current report

Refreshing the report has no effect

When I deleted a macro and save input-form? it's working correctly, but with macro, we have an issue.

What would be the cause of this issue?

[former_member186338]

Sorry, but do you really think that without detailed description with macro code it's possible to help you?

I can write a macro that will do many strange things 🙂

P.S. SP25 is very old, upgrade required.

[former_member186338]

Perform a clean installation of Windows 10 and MS Office (without other software).

Install fresh version of EPM Add-In.

Test

Add other required apps.

[former_member186338]

May be something is wrong with macro security settings in MS Excel?

Also it can be an effect of antivirus software - try to disable it for a moment.

[former_member381444]

Sorry, but disabling antivirus did not resolve the issue. Maybe something wrong with MS security?

[former_member186338]

vyacheslav_belousov

"Maybe something wrong with MS security?" - May be, but you have to investigate yourself with the help of Windows admin...

Can be a lot of reasons...

[former_member381444]

In MS settings everything is fine. Issue шs similar to that described in note:

2107965

https://answers.sap.com/questions/11415016/quick-fix-for-2107965-issues-in-epm-addin-after-in.html

[former_member186338]

vyacheslav_belousov

"In MS settings everything is fine" - then you will have no issues with EPM like me 🙂

Old note is not relevant.

[former_member381444]

Sorry I mean MS EXCEL settings is fine - as regular

[former_member186338]

vyacheslav_belousov

I do not understand "as regular". If you have issues then something is not fine.

And the only way to solve is to check all settings again and again. Without looking on your settings I can't help.

[former_member381444]

MS setting as regular I mean that I have 100 users with equal settings in EXCEL and 99 users working without problem on windows 7 another 1 have an issue on windows 10

Which settings you want to see?

[former_member186338]

vyacheslav_belousov

Sorry, but there are thousands of settings that may affect...

In general, nobody experienced today the same behavior...

[former_member381444]

SP 33 was previously installed, but the problem was the same. Any macro leads to this error, even Sub test () 'nothing end sub

[former_member186338]

Sorry, but this post is definitely not an "answer"! Use comments for posts like this.