Current Events > Any excel users here? Did they change Find and Replace in Excel?

(+) Yeah! (+)

One of the reports I have is poorly made and i basically have to copy a column (let's say G) into the next column (H) then find and replace a new file destination within the formulas across multiple sheets.

So from sheet 1 through 50 I have to replace the file that's being linked in column H to a current file, and I used to be able to select the sheets, select the column and it would replace within the formula across the sheets in one go, but now Excel is making me do it individually for each sheet instead. My coworkers are having the same issue. Is there a work around?
---