We have a huge folder containing office documents on our server. IT wants to change the name of the folder from Mehper_repository to Planning_reports. Since most of the Excel files in the subfolders are linked to each other, I need to find and replace every single cell content containing \\FileSrv\Mehper_repository\ to \\FileSrv\Planning_reports\. The problem is, Excel's Find/Replace utility can search only within Sheet or Workbook. How can I search within a folder/subfolders just looking in Formulas and replace that expression?
Excel – How to Find and Replace Link Paths in Multiple Files
find and replacemicrosoft-excel-2007
Related Solutions
Use =INDIRECT("'" & DATA & "Stresses'!$C$9").
Yes, the crude way to do this is to re-size excel to span both screens and then re-size each workbook independently and have each sit in the area of excel on each screen
It appears that he was on the right track, but he needs to use the restore down button for excel, re-size it and then manually re-size each workbook. If the workbooks are maximized, click the restore window button near the top right of excel to independently re size the workbook windows
Edit - you can also expand excel across both screens and go to view - arrange all - vertical
Related Question
- Excel – How to get Excel to pull data from multiple workbooks from exact dates based on an entered date
- Search for specific key word and replace entire cell contents with something else in LibreOffice Calc
- Excel – Is there any easy way to search for a specific word within a cell
- Excel – How to update automatically and continuously cell values in the master workbook, while the source workbooks are edited from different computers
Best Answer
I would suggest the commercial product PowerGREP :