M
maketoast
At work, we have a very large formula workbook consisting of many sheets.
This file should only be editable by our CEO. We're using Excel 2007 and
Excel Viewer 2007.
One of the pages, our "prep transfer form" has a dropdown menu and multiple
formulas are calculated by the value selected from the dropdown. Locking this
workbook is a huge hassle, since it has almost 100 sheets (I can write a
macro, but what if the password is forgotten?) Besides that, everyone else
should only have read-only access. We had planned to only install excel
viewer on the employee computers so that all they could do is view and print
the workbook, but apparently excel viewer doesn't allow you to select a value
from a dropdown. I really wish this functionality existed-- without it, excel
viewer can't view all of the information in the file. It only shows the first
value in the dropdown.
This file should only be editable by our CEO. We're using Excel 2007 and
Excel Viewer 2007.
One of the pages, our "prep transfer form" has a dropdown menu and multiple
formulas are calculated by the value selected from the dropdown. Locking this
workbook is a huge hassle, since it has almost 100 sheets (I can write a
macro, but what if the password is forgotten?) Besides that, everyone else
should only have read-only access. We had planned to only install excel
viewer on the employee computers so that all they could do is view and print
the workbook, but apparently excel viewer doesn't allow you to select a value
from a dropdown. I really wish this functionality existed-- without it, excel
viewer can't view all of the information in the file. It only shows the first
value in the dropdown.