So we have built that spreadsheet report which everybody wanted. And we were all eager to use it in your presentation. But in the last minute, its broken... there's #REF at our formula.... Wooww...
Now what?
He he he.... Oalah, just very simple, skip the coffee. :D
Of course, I am kidding, who would skip coffee for a bunch of formulas ?
So, we use Find / Replace to do the dirty work while we let the roasted beans restore sanity.
Just press Ctrl+` (it is the key next to 1), this will enable formula view. Now press Ctrl+H and change the spreadsheet formulas or input range en masse.
Replace #Ref with your formula.....
Just like picture up there....;)
What are you still waiting for?
Go get that espresso!
Gracias....;)
