Exporting to excel from SAP

[Guest]

Hello Microsoft Guru's

I need a little help from you guys.
What happens is when we take a list out of SAP:

List -> Save to PC file -> Save list in file... Spreadsheet.
then save the file as eg. filename.xls

When i open the file it looks like a excel file, but when i save the
changes in excel i get a window up that says:

filename.xls may contain features that are not compatible with Text
(tab delimited). Do you want to keep the workbook in this format?

°To keep this format, which leaves out any incompatible feature, click
Yes.

°To preserve the features, click No. Then save a copy in the latest
excel format.

°To see what might be lost, click Help.

Then again, If i say save as.. and select the original file then it
looks like it´s a .txt file not .xls and i have to save it especially
as .xls
I don´t want to have to tell people that they have to import the file into
Excel, just opening the file should be enough.

Does anyone know what i´m talking about???
I have talked to the people at SAP and they say it´s a Microsoft problem.

Thanks
SAPGirl

 

[Roger Govier]

Hi

I know nothing about SAP.
However, it sounds to me as though the output file is a .csv file, which
Excel will quite happily open.

When you save it, then you can select from the File type option to save
it as a .xls file and ignore the warnings.

If you have added any formulae, changed layouts, done any formatting
etc., then all of these will be saved as the .xls file which will not be
readable in the same way as the original .csv

In my opinion, when saving the file from SAP, you should be calling it
filename.csv, not filename.xls
After your save in Excel, you would then have the new filename.xls file
and your original file of filename.csv would still be there exactly as
exported from SAP.

 

[Guest]

Some notes from my SAP experience:

1) SAP people tend to hate MS Excel and so claim that problems exporting SAP
data to Excel are the fault of MSFT. That won't change.

2) SAP appears to save exported data as a .xls file, but with .csv
formatting. This makes no sense and I have never received a sensible
explanation for it, but this seems to be its mode of operation. Perhaps
someone can give more detail about this.

3) I don't use SAP any more (thank god), however I recall that various SAP
User groups had extensive information on this issue. Further, are there
people internal at your company (not SAP people) who know how to resolve
this? They may be a good resource as well.

Good luck.

Dave

 

[Guest]

Hi,
As i understand u have problem after opening the export file from SAP.
u are doing correct but when u save it after opening first time just change
type (microsoft excel workbook) then u will not get any problem.

regards
zafar