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!
just do a find and replace > select the range of affected area
CTRL+F > ALT+P
find what: #REF
Replace with : NewSheet
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?
