File Format Change

[CozNoleon]

I have a schedule that has links to multiple files which are in .xls format.

However in their wisdom the person who created the files decided to change to format to .xlsb this year. The rest of the filename has stayed the same.

Is there a way I can quickly change the extension in the formula in my sheet so that they now point to the .xlsb version?

I've tried using file - replace but that's not working as it's prompting me to Update Values. There are 1000's of links to 24 different workbooks so the thoughts of having to manually rebuild my schedule is turning my stomach as it's something that's evolved over years. To start from scratch would be a total nightmare.

Below is a redacted sample of how the old links work
='N:\Folder\subfolder\[Filename.xls]Tab1'!$W8

And this is what I need to change them to
='N:\Folder\subfolder\[Filename.xlsb]Tab1'!$W8

 

[Ron de Bruin]

Select the formula cells

Ctrl F
Select the Replace tab
xls in the find what
xlsb in the Replace with

Click on Replace all

 

[MARK858]

You should just be able to do a Find/Replace. Just make sure that the Lookin is set to formulas and the Match entire cell contents is not checked.
xls in the Find box and xlsb in the Replace with