Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas to a new workbook? Paste Special is different
Paste Special is showing a different list other than where you have radio
buttons. I am using Microsoft Excel 2003. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas to a new workbook? Paste Special is different
If you want the formulas not to point back to the original workbook you can
do as follows, in the source workbook do editreplace and replace = (the equal sign) with something like ^^^^, that will make them text strings, now select them and copy them and just paste them into the new/other workbook, then reverse the replace in both workbooks by replacing ^^^^ with =, done! -- Regards, Peo Sjoblom http://nwexcelsolutions.com "MS-Requestor" wrote in message ... Paste Special is showing a different list other than where you have radio buttons. I am using Microsoft Excel 2003. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas to a new workbook? Paste Special is different
I want to copy the formula only to a different workbook. If so how as I do
not see the the pop-up window having different radio buttons (which includes formula, validation, etc) when I click on Paste Special. Thanks for your help. "MS-Requestor" wrote: Paste Special is showing a different list other than where you have radio buttons. I am using Microsoft Excel 2003. Thanks in advance. |
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) | |||
paste special - formulas | Excel Worksheet Functions | |||
Paste special formulas? | Excel Discussion (Misc queries) | |||
How do you copy a sheet (with Formulas) to another Workbook? | Excel Discussion (Misc queries) | |||
copy and paste formulas | Excel Worksheet Functions |