Skip to Content
avatar image
Former Member

can anyone help me for This workbook can not be opened error occured in sap bpc?

when i was trying book publication through one team then it is working but while i was trying to do same thing from another team then it gives error "This workbook can not be opened ".

so can anyone have some idea about it.

Here,I have attached picture of this issue.

error.png (253.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 16 at 04:01 PM

    Hi,

    I have got solution for this issue.

    I have Excel Version 2016 in my system,Therefore it is unable to take Long path as shown in below screenshot.

    For Ex:- subfolder in 2 level.

    Thanks and Regards,

    Monica Bhayre

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02 at 07:31 PM

    Security? Team folder?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03 at 07:26 AM

    Hi Vadim,

    I have already added security task for ZBusiness_administra task profile you can see on below screen shot.

    And one more thing from Zconsolidation_Reporting task i am able to perform book publication when it contains less number of task as compaired to ZBusiness_administra. so why i am not able to perform book publishing from ZBusiness_administra.

    And if i am talking about user access so I am a team lead for both the task.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04 at 02:43 PM

    Are you sure the error is related to which team the user who is publishing the workbook is associated with? It may be a false association.

    The error "The workbook cannot be opened" often occurs if the workbook you are trying to publish is already opened in the excel client.

    Please make sure that no workbooks are opened before executing the Book Publication Wizard and check if the error still occurs.

    -Peter

    Add comment
    10|10000 characters needed characters exceeded