8192 rows limit when opening wk1 files ?

P

paul

Hello,

I am opening a .wk1 file, which contains around 60K rows,
but only the first 8192 rows appear in Excel.

Is there any way to have all the rows in the Excel file ?

Thanks,

Paul
 
H

Harlan Grove

I am opening a .wk1 file, which contains around 60K rows,
but only the first 8192 rows appear in Excel.

Is there any way to have all the rows in the Excel file ?
Click to expand...

WK1 as in Lotus 1-2-3 Release 2.x native file format? Such .WK1 files support a
single worksheet of 256 columns and 8,192 rows. PERIOD.

Did you generate this '.WK1' file using a program other then Lotus 1-2-3? If so,
it didn't generate a true .WK1 file. Bad all the other .WK? file formats
Excel supports also have 8,192 row limitations, except for .WKS files which have
only 2,048 rows.

If you created a worksheet with 60K rows in Excel then saved it in .WK1 format,
Excel saved only the first 8,192 rows. If you didn't save that file in a
different file format that supports > 8K rows, those other rows are lost & gone
forever.
 

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

how to open wk1 files in excel 2007 2
saving a spreadsheet in a .wk1 format? 1
Way around row limitation 4
What is the Excel 2007 rows limit for Excel 2003 macros? 0
VBA help (Empty row delete; coupled with 8192 non-contigious issue] 5
Paging File, Size Limit 11
Deleting blank rows 4
Merged Cells Limitations 1

Top