Worksheet row limitations.

D

DBogart

When I attempt to paste data in excess of 65,000 lines to an new blank Excel
2007 worksheet I get the message "files not loaded completely" with an
explanation that the file contains more than 1,046, 576 rows..., In fact the
file I am trying to paste does not have anywhere near that amount?

I have been able to work around this by converting files previously created
in Excel 2003, but wonder why I have to do this rather than just creating a
new worksheet in 2007?
 
R

Ron de Bruin

Hi DBogart
to an new blank Excel
2007 worksheet
Click to expand...

If your Default Save format in Excel 2007 is a 97-2003 workbook you only have 65000+ rows

Change it here to a 2007 format : Office button>Excel options...Save
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Excel 2007 export file size huge 1
How to have more than 65,000 rows in excel 2007 3
Can exceed 65,000rows in Excel? 13
I want Paste Special (not Paste Link) 2
XL2007 - Pivot Table Limitations 2
copy formulas from one worksheet to an entirely different workshee 2
Copy-Paste Chart into Word from Excel 2007 3

Top