2010 Bug ( i think )

[philrv]

Hi all.
Could somebody please shed some light on the reason office engineers made it available for users to choose to still edit cells after marking a workbook final?? What's the point of that?? And how do I prevent them from doing it? Thanks in advance

 

[Joe4]

I don't have Excel 2010, but I know if earlier versions there are ways to prevent users from editing your workbook.

1. Lock your cell and protect your worksheets (see: http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm)

2. Alternatively, you could set your workbook to be a read-only document, though it is quite easy to change it (so not the most secure way of doing it).

Option 1 is probably your best bet, as you can password protect the locks.

 

[RoryA]

http://office.microsoft.com/en-us/e...to-a-final-version-of-a-file-HA010354333.aspx

Note the "it's not a security feature" bit.

 

[philrv]

I don't have Excel 2010, but I know if earlier versions there are ways to prevent users from editing your workbook.

1. Lock your cell and protect your worksheets (see: http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm)

2. Alternatively, you could set your workbook to be a read-only document, though it is quite easy to change it (so not the most secure way of doing it).

Option 1 is probably your best bet, as you can password protect the locks.

Thanks joe, but I am way past that one. happy fishing!!

 

[Joe4]

Thanks joe, but I am way past that one. happy fishing!!

Sorry, I don't personally know your level of Excel expertise.

Just trying to answer the question you asked about how to prevent users from editing your workbook...

 

[philrv]

Thanks Joe. I appreciate it.