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,
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,