Can Find but not Replace in Excel
Posted: Sun Apr 08, 2007 9:31 am
Hi there,
I am evaluating this before purchase but need to understand why the program can find my text "WLGION2" but not replace it? The file is in Excel and has the text in 2 times in cells as well as 3 times in the VB code. As I say, the program finds all 5 but does not replace them.
I have studied the options and have the "Replace in MS Office Files", "Excel Formulas" and "Excel Macros" options selected as well as the "Force read only files" just in case. I have tried the Find & Replace as well as the Batch replace.
Any thoughts?
Also, will the program allow the renaming of folders as well?
Cheers
Richard
I am evaluating this before purchase but need to understand why the program can find my text "WLGION2" but not replace it? The file is in Excel and has the text in 2 times in cells as well as 3 times in the VB code. As I say, the program finds all 5 but does not replace them.
I have studied the options and have the "Replace in MS Office Files", "Excel Formulas" and "Excel Macros" options selected as well as the "Force read only files" just in case. I have tried the Find & Replace as well as the Batch replace.
Any thoughts?
Also, will the program allow the renaming of folders as well?
Cheers
Richard