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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |