Hi Jenniclair,
I did wonder whether the excel document was corrupted
Yes, that's the next thing I'd test. Assuming the worksheet
has less than 56 columns, you should be able to copy/paste
it into a Word document, as a Word table. Can you do that,
and do all the columns (and rows) come across? If yes, and
you link to this as the data source, do you get everything?
If an Excel sheet is corrupt, you could end up carrying the
problem across by copying/pasting the cells. The better
"test" is to export/save to a delimited text file format.
Then import the result into a new Excel workbook.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)