Excessive Rows In 2007 to 2003

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

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?
 
When he tries to save the 2007 workbook in 2003 format, he will get messges
that his 2007 workbook is incompatible with 2003 and that things will be
lost or not work properly in 2003.

Tyro
 
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/ImportExcessRowsOfData.xls
 
Back
Top