I have a simple workbook with three sheets. Two of the sheets provide data for calculations on the third sheet. I would like to replace a portion of the formulas in the sheet which calculates. I fill in the replace dialog and click on Find All. I have 12,150 instances of the string which I would like to replace. When I click on Replace All I get an Update Values dialog box which requests that I point to a particular Excel file. I can get rid of the dialog by pressing on the ESC button and then only one of the 12,150 instances is replaced. I don't want to press on ESC 12,150 times. Also I can't understand why I get the Update Values dialog box because my workbook does not link to another Excel file?
I am a beginner with Excel so I hope that there is a solution to this problem via the interface without VBA programming if possible. Please help!
I am a beginner with Excel so I hope that there is a solution to this problem via the interface without VBA programming if possible. Please help!