OK problem solved!

It turned out that I was specifying Extended Properties = Excel 8.0
when the spreadsheeth was written with an older version of Excel.
converted the spreadsheet to the newer version and then the update
worked!

Thanks,
Timoth

--
Message posted from http://www.ExcelForum.com