Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / Paste Special / Values for a whole spreadsheet ?
I have a large workbook with a number of sheets that extract data from other
programs. I need to distribute it by email to people who don't have access to those programs, for whom the links won't work. Is there a way of converting formulae to values for a whole book or sheet in the same way as for a selected range ? Thanks Colin2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / Paste Special / Values for a whole spreadsheet ?
Hi
I haven't tried it but I suppose you could group the sheets (right-click on a sheet tab and select 'Group all') and then click on the select all button (above row 1 and to the left of column A) and then Copy/Paste Special/Values. Make a copy before you try, though! Andy. "Colin2" wrote in message ... I have a large workbook with a number of sheets that extract data from other programs. I need to distribute it by email to people who don't have access to those programs, for whom the links won't work. Is there a way of converting formulae to values for a whole book or sheet in the same way as for a selected range ? Thanks Colin2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / Paste Special / Values for a whole spreadsheet ?
I assume you use lots for formula for links and for extracting data from
other programs. Try : Go to menu edit/link/break links.... Which will convert all external links (formula) to their current values for the whole file. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Colin2" wrote in message ... I have a large workbook with a number of sheets that extract data from other programs. I need to distribute it by email to people who don't have access to those programs, for whom the links won't work. Is there a way of converting formulae to values for a whole book or sheet in the same way as for a selected range ? Thanks Colin2 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / Paste Special / Values for a whole spreadsheet ?
Andy / Daniel
Many thanks for your responses - both work fine regards Colin2 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / Paste Special / Values for a whole spreadsheet ?
Thanks for the feedback and I'm glad you're sorted! I didn't suggest the
Links option because my version (XL2000) doesn't have it so I don't know it exists!! Cheers. Andy. "Colin2" wrote in message ... Andy / Daniel Many thanks for your responses - both work fine regards Colin2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy & paste special | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |