Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when 2007 is installed side-by-side with 2003, open xls with 2003 | Setting up and Configuration of Excel | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
question about excessive code in replacing #N/A when using VLOOKUP | Excel Discussion (Misc queries) | |||
excessive rows when scrolling down | Excel Worksheet Functions |