ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   overwriting my links (https://www.excelbanter.com/new-users-excel/173459-overwriting-my-links.html)

Joanne

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

Max

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




David Biddulph[_2_]

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





All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com