| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Special Paste
Help!
I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Paste
Rhonda,
Choose the "Paste Link" option. HTH, Bernie MS Excel MVP "Rhonda" wrote in message ... Help! I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Paste
What you describe will not work unless, when you did the first paste
special, you selected "Paste link." Otherwise it won't link. Select what you want to copy, move to the destination workbook and select Paste Link; in the dialog box check "Paste link" before selecting a format in the "as" box. "Rhonda" wrote in message ... Help! I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Paste
Hi Sir Bernie,
I wonder if there is a link that can help us to paste specialpaste link ALL incldg. cond. format with formula... regards -- ***** birds of the same feather flock together.. "Bernie Deitrick" wrote: Rhonda, Choose the "Paste Link" option. HTH, Bernie MS Excel MVP "Rhonda" wrote in message ... Help! I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Paste
driller,
Do a paste (which will paste everything, include conditional formatting with formulas) and then do the pastespecial paste links right after, which will create the links only. HTH, Bernie MS Excel MVP "driller" wrote in message ... Hi Sir Bernie, I wonder if there is a link that can help us to paste specialpaste link ALL incldg. cond. format with formula... regards -- ***** birds of the same feather flock together.. "Bernie Deitrick" wrote: Rhonda, Choose the "Paste Link" option. HTH, Bernie MS Excel MVP "Rhonda" wrote in message ... Help! I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special Paste
thanks for the info, sir Bernie,
i still don't know where i can find a smart add-in to do ALL paste special at once... maybe someone had already did it, and he/she will be helpful for easy tracking of multi-workbook linked all together... regards -- ***** birds of the same feather flock together.. "Bernie Deitrick" wrote: driller, Do a paste (which will paste everything, include conditional formatting with formulas) and then do the pastespecial paste links right after, which will create the links only. HTH, Bernie MS Excel MVP "driller" wrote in message ... Hi Sir Bernie, I wonder if there is a link that can help us to paste specialpaste link ALL incldg. cond. format with formula... regards -- ***** birds of the same feather flock together.. "Bernie Deitrick" wrote: Rhonda, Choose the "Paste Link" option. HTH, Bernie MS Excel MVP "Rhonda" wrote in message ... Help! I tried to copy some data from one workbook to another (special paste). Then I made changes to he initial workbook, when I went back to the workbook that I did the special paste - no update. I thought if I did a "special paste" - once I changed the data in the initial workbook, it will automatically change in the other workbook? I thank you in advance for your prompt response. Rhonda Randolph Medical University of South Carolina |
| 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) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
| Paste Special and Paste Object | Excel Discussion (Misc queries) | |||
| "paste special" "paste link" | Excel Discussion (Misc queries) | |||
Linear Mode
