LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 43
Default Exporting to excel from SAP

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


"SAPGirl" wrote:

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Exporting data from access to excel vinayak Excel Worksheet Functions 0 April 11th 06 08:20 AM
Exporting to Excel from a program like Oracle ralphdevlin via OfficeKB.com Excel Discussion (Misc queries) 0 March 28th 06 02:48 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 05:33 AM
Exporting numbers into Excel shedevel143 Excel Discussion (Misc queries) 1 December 11th 04 12:37 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"