开发者

how can I prevent Excel 2003 from checking every hyperlink in a document when the document opens?

开发者 https://www.devze.com 2023-04-10 02:46 出处:网络
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 with

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 som开发者_如何学Goe 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?


This is a programming-related forum so:

 Workbooks.Open AFile, False

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号