Excessive Rows In 2007 to 2003
 

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?

Excessive Rows In 2007 to 2003
 

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

"FARAZ QURESHI" wrote in message
...
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?

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?