If I understand you correctly, to rid yourself of the formulas
Select yout entire sheet (ctrl A) (make sure this is backup)
edit|copy
edit|paste special|values
Lance
"Les Ferrington" wrote:
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
|