Not Recognized Format

  • Thread starter Thread starter SKLwater
  • Start date Start date
S

SKLwater

I've written large workbooks with excel xp, but at home I am using excel
2000. Is there any way to convert the xls file format that xp uses so I can
work with the spreadsheet at home?
Thanks,
Alan
 
All versions of Excel since 97 use the same file format, so no
conversion is necessary. If you can't open the file, it is
probably corrupt.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
My wife just started saving her xls files at work to the network, instead of
her local drive. Any idea why when she tries to open them, they all come up
with Not Recognized Format? What would corrupt the files to or from the
network server? She brought one file home, and I got the same error.
Thanks,
Alan
 
Sometimes, excel files (.xls) are opened in MSWord and saved in Word format.
The next time you try to open them in excel, you find out that they're
corrupted.

If you can open the .xls file in MSWord, maybe that's what happened?

I save almost all my files on a network drive at work and I've only had a couple
of corrupted files--but I don't blame the network for them--I think the workbook
just went bad.

Is she still using the same version of Excel at work as before?
 
SKLwater wrote...
My wife just started saving her xls files at work to the network,
instead of her local drive. Any idea why when she tries to open
them, they all come up with Not Recognized Format? What
would corrupt the files to or from the network server? She
brought one file home, and I got the same error.
Click to expand...

If this is happening to your wife at work, and your wife's employer is
large enough to have a network, then your wife's employer should also
have an IT staff of some sort. Wouldn't they be the ones who need to
diagnose and fix this?

It could be a few things, but the most likely are bad network
connections or cables or antivirus software on the network server
screwing up the files. Either way, unless your the IT staff for your
wife's employer, I don's see how you or your wife fix this.

Two tests your wife could do at work. Save an Excel workbook to her own
PC's harddisk and save the same file to a server share. Then from a
console window (aka DOS prompt) compare the file sizes using the DIR
command.
dir C:\OwnDrive\YourFilenameHere.xls
Click to expand...
dir S:\ServerShare\YourFilenameHere.xls
Click to expand...

If the sizes aren't the same, call the IT people and bitch loudly. If
they're the same, use the FC command to compare their contents.
fc /B C:\OwnDrive\YourFilenameHere.xls
Click to expand...
S:\ServerShare\YourFilenameHere.xls

If they differ, call the IT people and bitch more quietly. If they
don't differ, copy the file on the server back to the harddisk using a
different filename, and try to open that copy.
 
Back
Top