cancel
Showing results for 
Search instead for 
Did you mean: 

Workbooks

Former Member
0 Kudos

Hi all,

I have a following situation:

I work on 3 computers and on all of it I have Exel 2007. I create workbooks and save them. But on first computer a workbook is saved with extension *.xls, on second - *.xlsm, and on third - *.xlsx. Why does it so? What and where I have to set up for saving my workbooks with one extension?

Regards,

Veronika.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Some more details:

On one computer I have SAP GUI 7100.1.4.3069. On another computers I have SAP GUI 7100.2.7.3077.

If I open a workbook on computer with SAP GUI 7100.1.4.3069 the workbook's extension is .xls.

If I open a workbook on computer with SAP GUI 7100.2.7.3077 the system automatically change extension to .xlsm and I can't open this workbook on first computer and can't execute this workbook on computers with Exel 2003.

Why does it so? How can I influence on it?

Regards, Veronika.

Former Member
0 Kudos

Please refer to OSS Note : 1061607 ..@ https://websmp101.sap-ag.de/notes

Cheers

Former Member
0 Kudos

Thank you very much for your answer!

Could you give me some information about SAP_BW_VIRTUAL_COMP? What is it? For what is it?

Regards,

Veronika.

Edited by: Veronika Vnukova on Jun 5, 2008 9:20 AM

Former Member
0 Kudos

And one more question:

I do all things that is described in this note. Now how and where I can change the extension of workbook?

Regards,

Veronika.

Former Member
0 Kudos

XLS

(*.XLS) Microsoft Excel 97-2003 Workbook

XLSX

(*.XLSX) Microsoft Open XML Excel Workbook

This is also the default file type as set in Excelu2019s:

Office Button>Excel Options>Save

XLSM

(*.XLSM) Excel Macro-Enabled Workbook

Change the settings as per your requirement.

Thanks...

Shambhu

Former Member
0 Kudos

On all computers this setting Office Button>Excel Options>Save is xls. But workbooks are different.