Glacial "Find and Replace"

[Guest]

1) Very large workbook >30M
2) There are extensive links to approx 80 other workbooks (not possible to open all at once
3) Find and Replace of "internally referenced" formulas fine, but very slow for formulas linked to other workbook
4) Takes approx 25 minutes to make about 8,000 "Find and Replace" change
5) Sample link: ='S:\Directory\Sub-directory1\Sub-directory2\[Ottawa.xls]GuardP&L'!$B$1
6) If there is no way to speed this up, can you suggest a good novel

 

[Nikos Yannacopoulos]

Stephen,

Looks like you're stretching Excel to the limit... I can't be sure about
this not having a clue what it's doing, but the size implies tons of data,
so considering a different, more suitable platform might be the way to go.
Access maybe? If this is a realistic option for you, I could give you some
hints on whether it's feasible / worth to transfer to Access, and top line
hints on how to, if I know more about it... I consider myself a somewhat
above average Excel user, and definitely a better Access one.

Nikos

1) Very large workbook >30MB
2) There are extensive links to approx 80 other workbooks (not possible to open all at once)
3) Find and Replace of "internally referenced" formulas fine, but very

slow for formulas linked to other workbooks

4) Takes approx 25 minutes to make about 8,000 "Find and Replace" changes
5) Sample link: ='S:\Directory\Sub-directory1\Sub-directory2\[Ottawa.xls]GuardP&L'!$B$13
6) If there is no way to speed this up, can you suggest a good novel.