Which version of Word?
In the dialog box you see with a blan klist of sheets, do you see an
"Options" button? If so,
a. click it and check all the 4 boxes in the dialog that appears.
b. the list of sheets should then appear
c. it suggests to me that you are using Word 2002 or 2003, in which case
- previously Word would have opened the sheet using its default method
(called "OLEDB")
- something has gone wrong that prevents that method from opening the
workbook
- the workbook may have been corrupted.
If (c) is correct then I think your best option is probably to reconstruct
your workbook. That may or may not be straightforward depending on how
complex it is, but if the /only/ complexity is that it is multi-sheet and it
would be easy to recreate any formulas etc., then you could
a. export each sheet into a separate .csv file
b. import each .csv file into a workbook (you may be able to import into
new sheets, or you may need to import each one into a new workbook and
copy/paste into a new sheet)
However, if you decide to try to reconstruct your workbook, I would have a
look around at Excel-oriented resources (e.g. an Excel-oriented group) to
see if there are well-known approaches/tools for recovering workbooks.
I suppose it is also possible that you have exceeded some limit in Excel
that I'm not aware of, e.g. if you have more than x sheets, perhaps the
OLEDB provider gives up. Does that ring any bells?
Peter Jamieson
