如何防止 Excel 2003 在打开文档时检查文档中的每个超链接?
我有一个电子表格,其中有多个工作表,每个工作表包含大约一百个指向我们网络上其他文档的超链接 (file:////server/share/path/to/spreadsheet.xls
)。与 2007 年或 2010 年打开这些文件所需的时间相比,在 Excel 2003 中打开这些文件需要很长时间。我在任务管理器的网络选项卡中查看了这些文件打开时发生的情况,并注意到文件打开时有大量稳定的网络流量,当电子表格最终显示在屏幕上时,网络流量几乎降至零。当我删除其中一些链接时,文件打开速度会更快,直到我最终删除所有链接,文件打开速度几乎与任何其他普通电子表格一样快。有没有办法阻止 Excel 在文件首次打开时对这些链接执行任何操作?
I have a spreadsheet that has several worksheets, each containing a hundred or so hyperlinks to other documents on our network (file:////server/share/path/to/spreadsheet.xls
). Opening these files within Excel 2003 takes a very long time, compared to how long it takes to open in 2007 or 2010. I took a look in Task Manager at the network tab to see what was going on when these files are opened and noticed a lot of steady network traffic while the file was opening, and as soon as the spreadsheet finally displayed on the screen, the network traffic dropped down to almost nothing. As I removed some of those links, the file would open faster, until I finally got rid of all the links and the file opened almost as fast as any other normal spreadsheet. Is there a way to prevent Excel from doing whatever it's doing with those links when the file first opens?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这是一个与编程相关的论坛,因此:
请参阅:http://msdn.microsoft。 com/en-us/library/ff194819.aspx
This is a programming-related forum so:
See: http://msdn.microsoft.com/en-us/library/ff194819.aspx