This may be very elementary (apologies in advance if that's the case), and my fear is that the Excel version of this file is
gone for good, but here goes in hopes someone has a solution...
We have a workbook with multiple worksheets saved
on a shared drive, with worksheets 2 through 11 in the workbook linked to cells in worksheet 1 in the same workbook. Not
that it's necessarily relevant, but edits are only made in worksheet 1. One of my employees tried to open the file earlier
today, said something looked strange about it, so he closed it, then reopened it, made some changes, then saved and closed it
When anyone (including him) now tries to open the file, they receive the infamous "file format is not
valid" error message. Although he says he doesn't recall the specifics, my suspicion is that he was in MS Word and
mistakenly tried to open the file there, saw the "Open Worksheet" popup, selected "Entire Workbook," saw that it looked a bit
different than the regular version (his "something strange" reference), closed it, then reopened it in Word, disregarded the
strange appearance, made his edits, and saved it, even after Word would've prompted him that it was going to save it in Word
I've been able to recreate the scenario exactly as detailed above using a test file, and although the file
still displays as being Excel format in Explorer, and still has the .xls extension, trying to open the test file from either
Explorer or directly within Excel gives me the same error we're getting with the one he played with.
I can open
the test file (and the bad one) in Word, and although I get the data, it's in tables stacked one on top of the other, and
with much of the formatting skewed. It isn't pretty, and doesn't give us the original template on which to build or adapt it
going forward. (I know---this is why we create backups, but getting our MIS folks to restore from backups isn't an easy
I guess I could take the tables one by one and copy them back into Excel, but that's a messy proposition
due to size, formatting, etc., and I'm hoping there's an easier alternative. Does anyone know ANY way to revert the file to
Excel format so that it can be opened there, ideally getting us back to the version before things went wrong? For reference,
we're using both Word and Excel 2000.
Thanks in advance for any help you can offer.