Excel should allow me to screen scrape the data only

[Guest]

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

 

[Guest]

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

 

[Debra Dalgleish]

To send the data only:

Create a copy of the workbook
Select the worksheet that you want to fix
Press Ctrl+A to select all the cells
Choose Edit>Copy
Choose Edit>Paste Special
Select Values, click OK

 

[Alan]

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,

 

[RWN]

In addition to the responses posted to you query.
I note that you said that you had some hidden data and did not want it
in the copy.
In that case you'll want to select "Visible Cells Only" before you copy
and paste.
Once you've highlighted (selected) the data to be copied;
"Edit->GoTo..->Special.." and select "Visible Cells Only" & ok.
Then Copy and Paste Special->Values only.
Ignoring this step will cause the hidden rows/columns to be pasted as
well.