E
Ed
I'm down to Row 8899 and out to Col AB on the front (data) sheet. It's got
about 9,000 hyperlinks in it. Sheets 2 and 3 are pages with different
search functions on them: one searches the data sheet and one searches
through all the Word docs the hyperlinks point to. The last sheet is a
"banner page" with a MsgBox that pops up only if they have macros enabled.
Click OK, it hides that sheet and lets you see the data. The whole file
saves at about 7.7 meg.
The problem is that it takes a long time to open, especially on some of the
slower computers (Pentium 100, anyone?). I guess they want it to pop open
like a text file with nothing in it! I'm using Excel 2000 and Win 2000.
Any suggestions for trimming the file-open time on this are greatly
appreciated!
Ed
about 9,000 hyperlinks in it. Sheets 2 and 3 are pages with different
search functions on them: one searches the data sheet and one searches
through all the Word docs the hyperlinks point to. The last sheet is a
"banner page" with a MsgBox that pops up only if they have macros enabled.
Click OK, it hides that sheet and lets you see the data. The whole file
saves at about 7.7 meg.
The problem is that it takes a long time to open, especially on some of the
slower computers (Pentium 100, anyone?). I guess they want it to pop open
like a text file with nothing in it! I'm using Excel 2000 and Win 2000.
Any suggestions for trimming the file-open time on this are greatly
appreciated!
Ed