We have a large Excel 2003 workbook. A copy is taken, openend (from a Sybase
PowerBuilder app) then data is populated into the various sheets. As each
cell is populated, cell validation is added (drop-down lists).

Running this routine against Excel 2003 works fine.

Running against Excel 2007, the initial export/population seems fine,
however after saving the spreadsheet, lots of the cell validation is lost.
Taking a file run against Excel 2003 and opening it in 2007, again after
saving (in the same file format, not the new .xlsx format) lots of validation
is lost.

The first X number of cells on the each sheet keep the validation, but all
others after that lose theirs. X is different for each sheet (in one case
539 cells keep their validation, in another its 576, and so on).

Anyone else seen anything similar? Are there new restrictions on the
amounts of validation allowed in 2007?

Any help much appreciated.