How can I extend maximum number of records when opening sylk file?

T

tony86

When opening a .slk file in Excel 2002 you can only see the first 32,767
records.

I have a file that is larger than this , and therefore I cannot see all of
the data.

I know that you can extend the maximum number of records when opening a text
file - I just need to know how to do it.

Can anybody help me please?
 
M

Myrna Larson

Opening a text file and a SYLK file are two different operations "under the
hood". If 32,767 is the limit, there's probably not much you can do about it.

Do you have control over the workbook from which the SLK file was produced? If
so, can you split it into two or more parts, import them into 2 workbooks,
then paste back together again?
 

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

I have lost 6 months work, how can i get my file back 1
Inconsistent formatting of section numbers 0
Problems created by Recent updates to Outlook 365 0
MS Word 2007 files taking too long to open after new internet connection 5
Make "File in use" message appear when 2 people open the a shared document in the same time 3
SYLK file format 2
Maximum record size and maximum number of records 3
How do I remove an Autoshape? 3

Top