ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting to CSV file (https://www.excelbanter.com/excel-discussion-misc-queries/124470-exporting-csv-file.html)

Paul Bytes

Exporting to CSV file
 
get an Excel window that popups up, file.csv may contain features that are
not compatible with CSV... Do you want to keep workbook in this format?
Yes - to keep format, which leaves out any incompatible features
No - to preserve features, click no

I select Yes, I want it to remove "incompatible features" and save as a true
CSV file. but the next time I save it, I keep getting the same Excel window

Sean Timmons

Exporting to CSV file
 
Although you are saving as a .CSV, you are re-opening with Excel. Once you do
this, any change you make may affect the formatting of the file. If you were
to open the file in, say, Wordpad, it would show with the commas, and if you
save from Wordpad, it would not give you the same warning.

In other words, you will continue to get this warning any time you attempt
to save any file from Excel as .CSV.

"Paul Bytes" wrote:

get an Excel window that popups up, file.csv may contain features that are
not compatible with CSV... Do you want to keep workbook in this format?
Yes - to keep format, which leaves out any incompatible features
No - to preserve features, click no

I select Yes, I want it to remove "incompatible features" and save as a true
CSV file. but the next time I save it, I keep getting the same Excel window



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com