A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel should allow me to screen scrape the data only



 
 
Thread Tools Display Modes
  #1  
Old October 18th, 2004, 12:35 AM
Les Ferrington
external usenet poster
 
Posts: n/a
Default 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
  #2  
Old October 18th, 2004, 12:43 AM
LanceB
external usenet poster
 
Posts: n/a
Default

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

  #3  
Old October 18th, 2004, 12:45 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

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 EditCopy
Choose EditPaste Special
Select Values, click OK

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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #5  
Old October 18th, 2004, 02:25 AM
RWN
external usenet poster
 
Posts: n/a
Default

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.

--
Regards;
Rob
------------------------------------------------------------------------
"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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is this possible with Excel Chart? q582gmzhi Charts and Charting 1 September 8th, 2004 03:33 AM
Automatically Updating Excel Data In Word Doc Inside Excel File Business Design Architect General Discussion 0 August 29th, 2004 10:55 PM
Problems with converting data held in an Excel spreadsheet to Word mark Gray Mailmerge 6 July 8th, 2004 10:54 AM
Excel Worksheets Richard General Discussion 2 July 8th, 2004 04:34 AM
Merging Excel Data into Word Document Debra Dalgleish Worksheet Functions 1 February 16th, 2004 01:15 AM


All times are GMT +1. The time now is 10:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.