Lucy

No version has unlimited row numbers
Excel 2007 has 1,048,576 rows and 16,384 columns.

If the OP has XL2007, then if he loads a workbook created in an earlier
version, it will open in compatibility mode and will be limited to 65,536
rows.
Saving the file in the XL2007 format of .xslx as opposed to .xls, then
closing and re-opening, will allow access to all 1,048,576 rows
--
Regards
Roger Govier



"Lucy Thomson (aka aneasiertomorrow)"
oft.com wrote in message
...
Older versions were limited to 65000 rows, 2007 has no limit. Are you
saving
as 97-2003 workbook?

Lucy

PS btw no-one here works for microsoft - we're just fellow users trying to
help our peers
--
MOS Master Instructor
www.aneasiertomorrow.com.au




"MrLetDownByVista&Office2007" wrote:

I need to make copy several worksheets and paste into 1 sheet to make 1
very
large worksheet. My problem is when I exported the data from Access I
was
not allowed to export any more than 65000 records at 1 time. Now when I
copy
1 sheet of 65000 and try to paste into the other worksheet under the
current
records the stupid program won't let me because there are not enough rows
to
paste into. This never happened in older versions of excel. I don't
know
what moron changed the sheet size settings but I would really appreciate
help
to make my worksheet have unlimited rows like tho older versions did.