I
Ian Elliott
Thanks for any help.
I have Excel 2002, and a workbook with about 800 cells, each with a link, to
about four different files. I am using global search and replace to change
the values, to the new filenames. But this takes about 2-3 minutes to do each
one. The global search and replace takes about a quarter second per cell. Is
there a way to turn off the calculation or link feature so that I can do a
global replace quicker than this?
I looked in Options and tried some things, but couldn't change anything.
Thanks again.
I have Excel 2002, and a workbook with about 800 cells, each with a link, to
about four different files. I am using global search and replace to change
the values, to the new filenames. But this takes about 2-3 minutes to do each
one. The global search and replace takes about a quarter second per cell. Is
there a way to turn off the calculation or link feature so that I can do a
global replace quicker than this?
I looked in Options and tried some things, but couldn't change anything.
Thanks again.