EPM (SAP-BPC add-in) in Excel doesn't work if other Excel's files are already open

Vebixir94 1 Reputation point
2022-07-05T10:25:16.933+00:00

We faced a problem with the add-in, when there are other Excel files already open. 

If an Excel file is already open, and you try to open a file generated by SAP, it will never open.
If you want to open ONLY the file generated by SAP, it works perfectly.

Can someone help me to try to fix it?

Thank you

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,320 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,618 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Emily Hua-MSFT 27,466 Reputation points
    2022-07-06T03:14:37.527+00:00

    Hi @Vebixir94

    Welcome to Q&A forum ~

    Could you please tell us which version of Office are you using?
    Please go to File > Account > Product Information, check the Office version name and version number.

    > If an Excel file is already open, and you try to open a file generated by SAP, it will never open.

    Under this case, is there any error message? If so, please share us for better analysis.

    • From the Office perspective, it is recommended to update Office to the latest.
    • Please back up the workbook first, go to File in Excel > click Open > Browse > select the workbook in the Open dialog box > click the arrow next to the Open button, and then click Open and Repair, repair the workbook.
    • I suggest you right-click on this workbook that generates from SAP to run as administrator after you open some workbooks.
    • Please also try to open this file in a new Excel instance.
      Double click the file (as you normally do to open it) and immediately after that press and hold the Alt key. Keep holding Alt until the new instance dialog box pops up. Click Yes to confirm that you want to start a new instance

    If these steps do not work, you can also repair Office from Control Panel.

    As this issue may be related to SAP-BPC add-in, to help you better, it's best post a new thread on SAP Community.
    (Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)
    Check if any other users are experiencing the same issue and if there are any settings or changes made to this add-in.
    Thanks for your understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.



  2. Dinh, Thien Loc 0 Reputation points
    2023-04-04T11:40:07.8366667+00:00

    Hello Support Team, My client's policy does not allow to enable the auto-update Can you share with me an offline patch to fix this issue, please Thank a lot Loc Dinh

    0 comments No comments