Tuesday, September 22, 2015

Excel flexible read-only mode

I have an Excel 2016 worksheet on a network drive that several people open and tend to keep open over the day.


There is a handful of users with Write rights and the need to save adjustments is perhaps like once a day or so. Users in Read-only rights also need to enter data in cells that would be used in Excel formulas, but obviously without the ability or need to save it.


Now the issue I'm trying to tackle is that if one of those users with Write rights actually needs to do any changes, there are limited chances he is the one that has locked the file for editing.


Any suggestions on how to make the users with Write rights not lock the file for editing unless they have an actual need to do so? I have two obvious options, however neither look usable here:


1) Shared Workbook - according to my experience, running Shared Workbook functionality does hinder the performance of Excel and I would not want that.


2) Excel standard "Enable editing" prompt before opening the Excel file with Write rights. If you don't enable editing, you are also not allowed to write stuff in cells, which is possible with regular read-only rights and is necessary.


Any suggestions? Going deep into Excel settings to turn something on/off each time when opening the file is not that appealing. Could something be done with 2 different shortcuts for the end user or some other straightforward approach?


Thanks!

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...