| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
overwriting my links
I have a ws with 17 columns, 8 of which are linked to a master ws
A user did a copy/paste over one of my columns and it overwrote my links Is there some form of 'paste special' that needs to be used so we can paste in new values without losing our links Thanks for the info Joanne |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
overwriting my links
Don't think so. Maybe just protect the 17 cols to prevent accidental
overwriting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joanne" wrote in message ... I have a ws with 17 columns, 8 of which are linked to a master ws A user did a copy/paste over one of my columns and it overwrote my links Is there some form of 'paste special' that needs to be used so we can paste in new values without losing our links Thanks for the info Joanne |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
overwriting my links
Copy, Select the range you want to paste over, Edit/ Go To/ Special/ Blanks,
and then paste. -- David Biddulph "Joanne" wrote in message ... I have a ws with 17 columns, 8 of which are linked to a master ws A user did a copy/paste over one of my columns and it overwrote my links Is there some form of 'paste special' that needs to be used so we can paste in new values without losing our links Thanks for the info Joanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overwriting cells | Excel Discussion (Misc queries) | |||
| Overwriting most of a workbook | Excel Discussion (Misc queries) | |||
| Overwriting #DIV/0 value using ISERROR | Excel Discussion (Misc queries) | |||
| Spreadsheets are overwriting each other | Excel Discussion (Misc queries) | |||
| Overwriting Cells | Excel Discussion (Misc queries) | |||
Linear Mode
