![]() |
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 |
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 |
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