如何在没有C#的情况下使Excel工作簿具有只读访问权限?

时间:2022-09-11 17:19:01

We have an Excel workbook which is similar to an Error Codes database. Unfortunately the application is written in such a way similar to IF (ExceptionCode != AnyPreviousExceptionCode) THEN (Make New Exception Code) which gives the messy problem of new, never before seen exception codes appearing on our monitoring software and requiring a team of analysts to investigate. The point being that this Excel workbook of Error Codes changes alot day to day, especially if a big release comes out.

我们有一个Excel工作簿,类似于错误代码数据库。不幸的是,应用程序是以类似于IF(ExceptionCode!= AnyPreviousExceptionCode)THEN(Make New Exception Code)的方式编写的,它给出了我们的监控软件上出现的新的,前所未见的异常代码的混乱问题,需要一个分析师团队来调查。关键是这个错误代码的Excel工作簿每天都在变化,特别是如果发布了一个大的版本。

The problem I have is that there is a team who needs to have this workbook open as they need to consult what error code is what, but there is also one person who needs to update this workbook. Excel of course gives full rights to whoever opens the workbook first and everyone else has to wait, however we have a global team so it's not a simple matter of going over to someone and telling them "please can you share the workbook to me".

我遇到的问题是,有一个团队需要打开此工作簿,因为他们需要查询错误代码是什么,但也有一个人需要更新此工作簿。 Excel当然给予首先打开工作簿的人以及其他人必须等待的完全权利,但是我们有一个全球团队,所以转到别人并告诉他们“请你能分享工作簿给我”并不是一件简单的事情。

Is it possible in Excel to set some users as read-only and other users as write access and have this reflect on the GUI so Excel doesn't make the write access user wait for the read-only user to close the workbook?

是否可以在Excel中将某些用户设置为只读,将其他用户设置为写访问权限并将其反映在GUI上,以便Excel不会使写访问用户等待只读用户关闭工作簿?

1 个解决方案

#1


2  

In Win7 for Excel 2003, 2007 & 2010 there is a dropdown arrow on the right side of the open button in the open dialog. If you click that you get an option to open the file as Read-Only. Can the non editing users open it like this?
Shift+Right Click on an excel file also gives the option to open as read only.

在Win7 for Excel 2003,2007和2010中,打开对话框中打开按钮右侧有一个下拉箭头。如果单击该按钮,则可以选择以只读方式打开文件。非编辑用户可以像这样打开它吗? Shift +右键单击excel文件还可以选择以只读方式打开。

Sorry man, did not see your question a month ago :)

对不起男人,一个月前没有看到你的问题:)

#1


2  

In Win7 for Excel 2003, 2007 & 2010 there is a dropdown arrow on the right side of the open button in the open dialog. If you click that you get an option to open the file as Read-Only. Can the non editing users open it like this?
Shift+Right Click on an excel file also gives the option to open as read only.

在Win7 for Excel 2003,2007和2010中,打开对话框中打开按钮右侧有一个下拉箭头。如果单击该按钮,则可以选择以只读方式打开文件。非编辑用户可以像这样打开它吗? Shift +右键单击excel文件还可以选择以只读方式打开。

Sorry man, did not see your question a month ago :)

对不起男人,一个月前没有看到你的问题:)