cancel
Showing results for 
Search instead for 
Did you mean: 

Workbook Excel format required xlsx

former_member199573
Active Participant
0 Kudos

Hi,

The workbooks are stored in RSRWBINDEX and some are having XLSX and some XLSB.

I would like to know which setting causes this difference and we only provide the description when saving a new workbook.

The problem is that when the workbook is broadcasted, it is sending the workbook in XLSB format But, the requirement is to have it in XLSX.

Please let me know how to solve this.

Regards,

Raj.

Accepted Solutions (1)

Accepted Solutions (1)

MartinMaruskin
Active Contributor
0 Kudos

Raj, have a look into transaction RS_FRONTEND_INIT and in table table - RSFRONTENDINIT regarding parameters of MS Excel in BW workbooks.

cheers

m./

Answers (2)

Answers (2)

former_member199573
Active Participant
0 Kudos

Hi Suchitra,

Thank you for your response. I already checked the link but, could not find the solution to my problem.

Please let me know if you have any suggestion.

Hi Martin,

Thank you for your response.

I also checked your blog,

But, could not find the solution to my problem, Can you please suggest how to choose the excel type to XLSX as the workbook is stored in XLSB format in the BW table and the user do not want to receive the broadcasted workbook in this format.

Regards,

Raj.

MartinMaruskin
Active Contributor
0 Kudos

Hi Raj,

I suggested customizing of table RSFRONTENDINIT before. But after deeper look at your issue I think you may resolve this at client side.

Can you have  a look what is following default settings at your user's laptop?

While you are in Bex Analyzer go to menu: GlobalSetting->Default Workbook tab and make sure yoru users do not have selected the option "Use XLS File Format".

I think by this newly created WB should be stored in XLSX format and subsequently stored in XLSB format in DB. Give it a try..

cheers

m./

former_member199573
Active Participant
0 Kudos

Hi Martin,

Thank you for your suggestion.

My issue is that when the workbook is broadcasted, it is sending the workbook in XLSB format But, the requirement is to have it in XLSX.

The workbook is stored in RSRWBINDEX in XLSB format.

I tried saving the workbook without the setting use XLS format in the Analyzer settings But, it is saving with XLSB extension in RSRWBINDEX.

Please let me know if you have any suggestion.

Regards,

Raj.

Former Member
0 Kudos

Check out this link. Hope it will help.

http://wiki.scn.sap.com/wiki/x/gBUMDg

Regards,

Suchitra