I'm seeking advice on how best to share a workbook. I know how to password protect a workbook and how to lock-down cells or range of cells to certain users for editing purposes within a workbook.
BUT, how can we share a workbook so individual worksheets are password protected and/or certain individuals can't see or view certain worksheets within a workbook?
We are trying to figure out how to make this work because we have a lot of data that requires input from many individuals, but we don't want the individuals to view data from other individuals.... but since all the worksheets link to a master worksheet, it is easiest to have it all in a central location for everyone to access.
We have tried linking individual worksheets in individual workbooks up to a master workbook - but we can't figure out how to cross link and formatting never comes across, which makes it difficult to manage in that way.
ideas?
Bookmarks