excel 2000 cannot read record 100 in SYLK files it itself writes

[Jaap]

As in the subject, the problem is as follows:
If Excel 2000 writes a sheet in SYLK format, it has problems opening the ..SLK file.
The message is: cannot read record 100

This happens even with an empty sheet.
The latest updates are all installed.
Excel runs on Windows 2000.

How to proceed?


Jaap.

 

[Dave Peterson]

I've never used a .slk file in real life, but I just created a test file with
"asdf" in A1:E200.

I saved it as a .slk file, closed it and reopened it.

I got the same error along with 103, 106, and 109. But the data looked ok.

I put some unique data in those rows and did it again.

It looked like it was brought in correctly--even with the errors.

Maybe you could open the .slk file in your favorite text editor to see if the
data came in ok.

Not a good answer...

I did search google for "cannot read record" and sylk and found a couple of
hits--yours and one that blamed regional settings (theirs were set to Dutch and
needed to be USA).

I _thought_ my settings were set for USA, so that doesn't quite jibe for me.

You may want to see if your settings are ok.

 

[Jaap]

In (e-mail address removed),
Dave Peterson <[email protected]> typed:
:: I've never used a .slk file in real life, but I just created a test
:: file with "asdf" in A1:E200.
::
:: I saved it as a .slk file, closed it and reopened it.
::
:: I got the same error along with 103, 106, and 109. But the data
:: looked ok.
::
:: I put some unique data in those rows and did it again.
::
:: It looked like it was brought in correctly--even with the errors.
::
:: Maybe you could open the .slk file in your favorite text editor to
:: see if the
:: data came in ok.
::
:: Not a good answer...
::
:: I did search google for "cannot read record" and sylk and found a
:: couple of hits--yours and one that blamed regional settings (theirs
:: were set to Dutch and needed to be USA).
::
:: I _thought_ my settings were set for USA, so that doesn't quite jibe
:: for me.
::
:: You may want to see if your settings are ok.


Thank you for your effort.

I managed to make the file readable without complaints by taking out the lines

P;P_ "$"* #,##0_ ;;_ "$"* \-#,##0_ ;;_ "$"* "-"_ ;;_ @_
P;P_ * #,##0_ ;;_ * \-#,##0_ ;;_ * "-"_ ;;_ @_
P;P_ "$"* #,##0.00_ ;;_ "$"* \-#,##0.00_ ;;_ "$"* "-"??_ ;;_ @_
P;P_ * #,##0.00_ ;;_ * \-#,##0.00_ ;;_ * "-"??_ ;;_ @_

Not sure what they are good for though. It looks like formatting for currency. My locale
is set to English (united states) but date time and currency formatting is changed to
dd-MM-yyyy, HH:mm:ss and Euro. Seeing the dollar signs in the lines above, I changed
currency to $, but that did not do the trick.

Since I am trying to create .slk files from another application, and it is now clear that
Excel creates it's own problems when it writes a .slk file, I can live with that.

Thanks again for reproducing it on your computer.

Jaap.

 

[Dave Peterson]

I still don't use .slk files <bg>, but you may want to read more about them:

http://www.codemanual.net/main/file_formats/files/sylk.zip