LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default Save as CSV not saving the same from Excel 2007 then in Excel 2003

If I take an Excel file and Save it as a CSV in Excel 2003 the blank rows
from the Excel file show up on the CSV as blank rows (no commas show in that
row)

But when I save the same file in Excel 2007 (which we recently upgraded) the
blank rows from Excel show up as about 15 commas on the CSV file. There are
also other rows of data in the CSV file that have 5-10 extra commas appended
to the end.

Is there an option in Excel 2007 to save as CSV file but exclude blank rows?
 
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
saving with excel 2007 and oppening with excel 2003 fsantos Excel Discussion (Misc queries) 2 April 1st 10 06:15 PM
Formatting lost when saving excel 2003 file using excel 2007 Anamika Excel Discussion (Misc queries) 1 December 29th 08 04:24 PM
Unable to save modified Excel 2003 worksheets using Excel 2007 vkeller Excel Discussion (Misc queries) 0 May 9th 08 10:38 PM
Saving Excel 2007 conditional formatting in Excel 2003 format [email protected] Excel Discussion (Misc queries) 0 March 28th 08 06:42 AM
Excel 2003: File->Close without saving changes (save menu does no. Wai-Yee Excel Discussion (Misc queries) 5 July 25th 05 11:49 PM


All times are GMT +1. The time now is 03:52 AM.

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"