如何防止 Excel 2003 在打开文档时检查文档中的每个超链接?

发布于 2024-12-07 00:51:35 字数 337 浏览 0 评论 0原文

我有一个电子表格,其中有多个工作表,每个工作表包含大约一百个指向我们网络上其他文档的超链接 (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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

青朷 2024-12-14 00:51:35

这是一个与编程相关的论坛,因此:

 Workbooks.Open AFile, False

请参阅:http://msdn.microsoft。 com/en-us/library/ff194819.aspx

This is a programming-related forum so:

 Workbooks.Open AFile, False

See: http://msdn.microsoft.com/en-us/library/ff194819.aspx

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文