View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Locking updated cells

Good Day,

I have a spreadsheet that goes out to other (monthly) spreadsheets and
updates values. Once these Monthly spreadsheets are generated, the numbers
are considered final.

Is there a way to make Excel only grab a value from the Monthly spreadsheet
one time (basically if a value is in the cell, don't update it)? I have
concerns that someone will delete/alter one of the Monthly Spreadsheets and
it will ruin the spreadsheet I have created.

Thank you in advance,

Greg