Thread
:
Excel should allow me to screen scrape the data only
View Single Post
#
4
October 18th, 2004, 12:48 AM
Alan
external usenet poster
Posts: n/a
Make a copy of your workbook. In the copy, highlight the whole sheet(s) by
clicking the tab above '1' and to the left of 'A' in the top left hand
corner, right click in the highlighted area, Copy, right click again, Paste
Special, check 'Values'. OK
All formulas will be gone, the data will still be there, send it off,
Regards,
"Les Ferrington" Les
wrote in message
...
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
Alan