The problem is that the references are being saved. You should develop
your workbook in the oldest version and distribute that. Then there would
not be a conflict. Newer versions are smart enough to know about older
versions, but obviously not vice versa.

--
Regards,
Tom Ogilvy

"Marcus" /uk wrote in message
...
I have encountered a problem with referencing. Is it
possible to save references within a excel spreadsheet. So
when you send a spreadsheet to a number of people on
different excel version they I do not encounter
referencing problems.
For example they have Excel8.olb rather than Excel9.olb

Many thank

Marcus