Protection

[pnrymmf]

How can i password protect a workbook so that when you elect read only it will still not allow links to the spreadsheet to be updated?
I have several PMs updating their individual spreadsheets which link to a main workbook. I have to allow other people in my organization to view the main workbook but do not want them to be able to update the spreadsheet by the links due to some manual work that has to be done. Currently, the workbook is password protected but if you open it in read only, it still prompts you to update the links and will allow them to save their changes. Thanks,

 

[alizok]

Hello,
I'm not sure what you mean when you say that the file is read-only and yet it allow them to save the changes. That should not happen if the file in the read-only mode. Just make sure that when you save your work it is save under read only. If you have excel xp do the following: Go to save as -> on top TOOLS -> GENERAL OPTIONS -> enter the passwork for modifications not for open file. This feture should would allow other people look at your file make any changes they want but would ask them to save under a different name. So, that your file would be unchanges.
Hope that helps.
~alizok