Locking updated cells

G

Greg

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
 
E

Eduardo

Hi,
you can protect you worksheet but the password can be easily broken with
products that are in the market, other option is to keep a copy as a backup
 
Top