Commas generated in csv files for blank rows in Excel 2007

Grasshopper

Guest

Posts: n/a

20th Jun 2008

Salutations to the wise and experienced -

In previous versions of Excel, worksheets with blank rows saved as CSV
resulted in those blank rows creating only line breaks ( carriage returns) in
the exported file. Now it seems like a blank row results in a row of commas
(one for each column of data). Is there a switch, setting, tweak, to get the
old (Excel 97 to 2003) behavior to work in Excel 2007? I really need those
blank lines in the resulting file. I appreciate any assistance you could
provide.

« IRR - inflow first, followed by only outflows | Creating a button... »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 spreadsheet - blank rows	pc4n6	Microsoft Excel Misc	2	28th Sep 2009 10:17 PM
Why is Excel 2007 macro creating extra blank rows?	childofthe1980s	Microsoft Excel Programming	0	16th Jul 2009 09:27 PM
Excel 2007 CSV Format and blank rows	Karl427	Windows XP	4	17th Jun 2009 10:59 PM
respostX2 - deleting blank rows after macro-generated pivot table	klysell	Microsoft Excel Programming	0	11th Feb 2008 04:51 PM
respostX2 - deleting blank rows after macro-generated pivot table	klysell	Microsoft Excel Programming	0	11th Feb 2008 04:50 PM