Search code examples
excelexcel-2007excel-formula

Replacing all occurences in a sheet full of excel formulas

In an Excel sheets there is a ton formulas with references to another sheet:

e.g. the formulas in the first few cells are written out here:

           A                                           B

   1      '[Another sheet 11.xls]Grill'!BD19            ...
   2      '[Another sheet 11.xls]Grill'!BF129
   3      '[Another sheet 11.xls]Grill'!AD29
   4      '[Another sheet 11.xls]Grill'!KA123
   5      ...

Is there any general way of going about replacing "[Another sheet 11.xls]" with "".

The data was copied from another sheet to begin with hence the borked references. Is there any other way of telling excel to keep the references in the same sheet?

xD Namaste

Solution

  • Found the [simple] answer:

    Search and replace => on formulas

    :)