将 VSTO 文档解决方案部署到 Excel 2003
我们有一个 Excel 工作簿,其中包含 C# VSTO 代码和位于其后面的两个 .NET DLL。该电子表格过去适用于组织中的所有用户。
最近,我们的 IT 部门遇到了 OU 的问题,删除了所有用户帐户。帐户已恢复,但从那时起,我们伦敦办事处的用户在加载电子表格时就无法使用附加功能。只有纽约办事处的用户和一名开发人员(此后编译了该解决方案)可以使用该功能。
我们从互联网上遵循了一些操作方法,但没有成功,包括: http://msdn.microsoft.com/en-us/library/ bb332051.aspx#8
我们怀疑存在安全问题,因为我们代码的第一行是日志消息,但没有被命中。
Excel 没有给出错误消息,电子表格打开并且可用,但无法访问任何代码,并且所有按钮均被禁用。
任何帮助将不胜感激,因为我们花了很多时间试图解决这个问题!
谢谢
****************编辑********************************< /p>
以下是我的 IT 部门提供的问题的实际原因:
...是由它们所在的组织单位容器引起的
已删除。这已恢复,组成员资格和通讯组列表访问
然后手动添加个人帐户
We have an Excel workbook which has c# VSTO code in it and two .NET DLLs that sit behind it. The spreadsheet used to work for all users in the organisation.
Recently our IT department had a problem with the OU which deleted all user accounts. The accounts were restored but since then users in our London office have not had the added functionality when they load the spreadsheet. Only users in the New York office and one developer (who has compiled the solution since) can use the functionality.
We've followed several how-to's from the internet to no avail, including:
http://msdn.microsoft.com/en-us/library/bb332051.aspx#8
We have a suspicion that there is a security problem as the first line of our code is a logging message and this is not being hit.
No error message is given by excel, the spreadsheet opens and is usable but there is no access to any code and all buttons are disabled.
Any help would be massively appreciated as we've spent many hours trying to figure this out!
Thanks
***************EDIT******************************
Here's the actual cause of the problem from my IT Dept:
...was caused by the Organisational Unit container they were held in being
deleted. This was restored and group memberships and distribution lists access
for individual accounts were then added manually
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
事实证明,问题在于周末 IT 部门已将我们所有的 Excel 版本从专业版降级为标准版。并非所有 VSTO 都适用于 Excel Standard,但它并没有告诉您这一点,它只是不起作用。
升级后我们又开心了!
干杯
Turns out the problem was that over the weekend IT had downgraded all our versions of Excel from Professional to Standard. Not all VSTO works in Excel Standard, but it doesn't tell you this, it just doesn't work.
After upgrading we're all happy again!
Cheers