View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garrett Garrett is offline
external usenet poster
 
Posts: 10
Default automatically locked cells

How I can prevent my linking from one Excel file to another Excel file from
being locked? If I make one cell on file one = to a cell on file two then
it automatically adds the $ to lock the cells. I have to go into each cell
and remove it to fill by dragging. i don't want this. If I can't prevent it,
can I remove them in a bulk way instead of having to go into each cell to
remove the "$"?