how to Set default Workbook as .XLS for Bex 7.0

[Former Member]

Dear Experts,

I have a customised default workbook set for Bex 7.0. The Extention of this Workbook is .XLSM

Currently it is not accessible using Excel 2003 due to format issue.

1)Kindly let me know what should be done so that I can open this Workbook in Excel 2003.

2) Suggest a way to set the default extension for Bex 7.0 "Custom" workbook (Not SAP standard, the option is available in Global settings-->Default workbook) to .XLS.

Thank you,

Nandita

[former_member186696 · Accepted solution]

Dear Nandita,

The only correction for this situation is documented on these two notes below:

1339061 - BExAnalyzer: opening XL 2007 files in XL 2003 not possible

1267924 - BExAnalyzer: Use XLS as File Format when using Excel 2007

With Frontend Patch 800 a new property "Use XLS File Format" in "Global

Settings" dialog is available when using BExAnalyzer with Excel 2007 and

the SAP Default Workbook is being used.

So, everytime when you created a new workbook, check the flag of "Use XLS File Format" checkbox and save the workbook.

Then you will be able to open with Excel 2003.

Best Regards,

Edward John

[Former Member · Accepted solution]

This setting that is discussed, "Use XLS file format" - Does anyone know where this setting is stored on a user's local machine?

We have been searching through the SAP folder directory in search of any config or .ini files, as well as going through the registry. Our hope is to find how this setting is saved on a users machine because we want to use a software push tool (LANDesk) to force this parameter to be checkmarked on all of our users machines.

Can anyone shed any light on this? Thanks

[enginimaldb · Accepted solution]

You can find the setting "use XLS-file format" in BEx Analyzer under "global settings" in the second tab. It is only available to set if you are running BEx with Excel 2007.