IBP: An error occurred while opening the planning view error

[willsuus]

I tried to open a favorite that I have used in the past and got the error "An error occurred while opening the planning view and you may notice irregularities during use." When I click on OK to close this message, I then get the message "Can't find project or library". If I go in to the VB editor to determine what project/library was missing, when I click on References, nothing shows up.

This has happened before to other favorites/templates and I have not been able to determine the root cause or how to resolve this.

[former_member194529 · Accepted solution]

Hello Susan,

Gotcha. You've mentioned that this is happening only on a specific computer and that another end user can open the exact same favorite without issues. Is that correct?

In that case I would advise you to report an incident under the SCM-IBP-XLS-UI component and provide the extended traces for deeper technical analysis:

2477564 - IBP: How to generate logs and traces (including Performance) in Excel

Best,

Ivan

[former_member194529]

Hi Susan,

Have you tried the troubleshooting steps suggested on below SAP Note already?:

2729807 - IBP Excel Add-in error : Unexpected error occurred while working with SAP IBP planning vie...

Please give an special attention to the first recommended solution, for which after applied, will make Microsoft Excel recompile the VBA code and frequently fixes similar issues happening to other IBP customers.

Best,

Ivan

[willsuus]

Thank you, Ivan, for the quick response.

I had not tried this solution as of yet as it requires administrative permissions which we are not given on our laptops. I will need to work with our desktop support to see if this will resolve the issue.

In the meantime, can you explain why this is happening? The favorite had worked the last time I used it and, in fact, another user had opened it today and had no problem.

Also, is there another way to force Excel to recompile the VBA code?

[willsuus]

Hello Ivan,

I was actually able to add the Dword in the instructions - though I had to add both the Excel and Options folders under th 16.0 folder. Unfortunately, when I then went and tried to open the favorite, I still received the same error.

Susan