Update relating formuals when changing a column name?

[ISW]

Is it possible to update the formalas in the same query when changing a column name.

Example:

Original name - Depletion Tracker
Change to - Depletion_Tracker

Formula in another column has XYZ/Depletion Tracker

Do I have to go in with notepad and replace all the formulas? Is there an easier way to do this or am I just looking for an easy way out?

 

[Joe4]

That's pretty much how I do it, except I copy it out to Word and using Search and Replace.

 

[boblarson]

You can use the free V-Tools which has Total Deep Search and it can replace in all of the places you are using it. That can save time. I also use Rick Fisher's Find & Replace which has more options but it is about US $40 but it is worth it.

 

[ISW]

Thanks for the responses.

Notepad has the find and replace feature also.

I will look into those tools.

Thanks again guys.

 

[boblarson]

Thanks for the responses.

Notepad has the find and replace feature also.

The benefit to Total Deep Search or Find & Replace is that you do not need to go open things up to do it. And when doing queries, that can be important as it will get screwed up if you open it after something has been changed.