View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Need to export to a CSV but my file has more than 65536 rows

Do you mean that you have follow-on rows in a second sheet in the same
file?

Pete

On Jan 29, 8:30*pm, laredotornado wrote:
Hi,

I'm using MS Excel 2003 on Win XP. *I have a very large file and when
I open it I only see 65,536 rows. *I want to save it to CSV (text) but
I'm afraid if I do "Save As..." I'll only be saving out the first
65,536 rows.

Is there a way to export to CSV and keep all rows?

Thanks, - Dave