View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Excessive Rows In 2007 to 2003

Tyro is correct.

There is an alternative that could be used at your end if your colleague
runs into problems and isn't sure how to split the rows across 2 or more
sheets. He could save the worksheet as a .csv file and send that to you.

You could download my workbook that can read .csv files with virtually
unlimited rows of data into an Excel workbook, splitting them across multiple
sheets as required. It does limit the columns to the column limit of the
version of Excel you're using. You could then copy the sheets into another
workbook if you wanted to.

My workbook is available at:
http://www.jlathamsite.com/Tools/Imp...RowsOfData.xls


"FARAZ QURESHI" wrote:

Uptil now I am receiving an updating file from an office colleague being
saved on 2003 version. He is using 2007.

What if his records exceed 65536, would the file still be convertible? What
would be the consequences?