Excel should allow me to screen scrape the data only

When dealing with business partners I have a need to send them price lists in
excel format so they can 'use' the data meaningfully, however I don't want
them to see all the underlying formulae and hidden rows/columns. Right now I
have no option but to convert the spreadsheet into an Acrobat document making
it less useful to them

What Excel needs is a way of deleting all the underlying formulae and
functions in a spreadsheet while keeping the visible data in the spreadsheet,
a 'snapshot' if you will. I could then send the visble data to my business
partners in 'usable' spreadsheet format. Does anyone know how to achieve this

I am presently using Office 2003 but this comment applies to all versions of
Excel