I've an excel file with a lot of formulas that referenced an old sheet.

I've deleted it and now the forumla went from:

sumifs(RawData!$A:A)

to:

sumifs(!"Ref#!$A:A)

How to change to replace !Ref# with "NewSheet" in all cell?

Common Search and Replace didn't do it!

CodePudding user response：

just do a find and replace > select the range of affected area CTRL F > ALT P
find what: #REF Replace with : NewSheet

CodePudding user response：

Let me show you, using a screenshot, how I did it. Be aware that I just search on REF! (or REF!A, just to be sure how it works):

There is one important difference between my case and yours:
On my Excel sheet, I see #REF! while you mention REF#! (mind the position of the # character).

Are you sure you're not simply dealing with a typo?