Locking updated cells

  • Thread starter Thread starter Greg
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Tracking Historic Data 4
Sorting based on one column 1
Prevent paste from re-formatting cell 4
Monthly workbooks. Help???? 6
Retrieve data when multiple criteria need to be met 6
Automatically shift chart data range 4
Sumif formula 4

Back
Top