Skip to Content
0

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

Apr 02 at 04:57 PM

81

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Apr 02 at 07:31 PM
0

Security? Team folder?

Share
10 |10000 characters needed characters left characters exceeded
Monica Bhayre Apr 03 at 07:26 AM
0

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.


Show 8 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but to answer your question more info has to be provided including full details of publication setup with screenshots.

0

Hi,

Above three highlighted reports in the EFS_Overview template linked to ZTM_Business_Admin folder is generating error as shown in below screenshot.

But when I try to publish the same reports by linking them to ZTM_CONSOL_REPORTING folder,it runs successfully,and it has less tasks as can be seen in the initial screenshots.

picture1.png (265.8 kB)
template1.png (20.1 kB)
0

Not clear, what team is used to publish?

0

I am in both the team(ZTM_CONSOL_REPORTING and ZTM_Business_Admin) as a team lead but when I try to publish the same reports by linking them to ZTM_CONSOL_REPORTING folder,it runs successfully. but through ZTM_Business_Admin is generating error.And I have to publish book from ZTM_Business_Admin.


0

Are you able to manually open the template from ZTM_Business_Admin?

0

Hi,

yes, i am able to open the template from ZTM_Business_Admin. it works good.

0

Hi Vadim,

Do you have any update regarding this issue?

Thanks and Regards,

Monica

0

Some tests have to be performed.

Create a simple report and distribution template.

Create test users.

Test

0
Peter KREUTLEIN
Apr 04 at 02:43 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thankyou,

Workbooks are already closed and still its not working.

0