Flexfind: Search and replace made easy

What is FlexFind

Flexfind eases searching throughout an entire Excel workbook. Enter a string to search for and get a list of all found locations. Click on an entry to go there. Select workbook, sheet or range searching. Replace with another string in the found items you select. At your wish, get a confirmation for each occurrence found (also within one cell).

Flexfind add-in for Excel

Ever needed to replace a company name in the title of 25 charts? Or replace just the third occurrence of a cell address in some cells' formulas? Or change a part of the header of 6 sheets? Flexfind enables you to do so.

Flexfind is free of charge and works in Excel 2003, 2007, 2010, 2013, 2016, 2019, 2021 and 365 both 32 and 64 bits.

If you really like Flexfind, please consider donating to help support it's future development:
Paypal donate button


Please read: Excel add-ins fail to load

Current versions of Excel (2007 and up, Mac Excel)

Flexfind  v5.3, build 617 (Jan 16, 2023, Downloaded: 39.210 times)

This is the version for all versions as of Excel 2007, including Mac Excel (beta).

This version cannot be used with versions prior to Excel 2007.

Excel 2003

Flexfind for Excel 2003  v5.3, build 588 (27 Oct 2015, Downloaded: 49.933 times) See Screenshot

Mac version

For Mac users having issues with the 2007 version above, Flexfind 5.1 (Downloaded: 8.333 times) is still available.

Excel on-line

Here is a version of Flexfind which works in Excel on-line.

Recent Changes

5.3 Build 617: bugfix

Installation Instructions

Download the correct zip file using the links above. Unpack the files in the zip file to a folder of your liking and open the file called "Setup Flexfind.xls". Press the button in that file to install.



Showing last 8 comments of 281 in total (Show All Comments):


Comment by: Helge Larsen (11-12-2021 22:01:00) deeplink to this comment

I have recently installed FlexFind and find it very usefull. However, instead of activating FlexFind by clicking the button in the Add-ins tab of the ribbon, I am trying to activate it from a user-defined ribbon tab where I have collected many utilities that I use a lot. Therefore, I am missing the name of the VBA routine in FlexFind.xlam that starts the utility. I would really appreciate, if you can supply me with this routine name - if at all it is possible to call it from another VBA project.
Kind regards,

Comment by: Jan Karel Pieterse (12-12-2021 00:30:00) deeplink to this comment

Hi Helge,

There should be a button on the far right of your home tab, perhaps you can add it to your QAT?

Comment by: Keith Bales (18-12-2021 23:27:00) deeplink to this comment

When I updated FlexFind build 590 to build 601 in Microsoft 365 Excel and now I'm getting the dreaded "Cannot run the macro 'FlexFind2007'. The macro may not be available in this workbook or all macros may be disabled." I thought I was able to fix this on previous installations but can't get FlexFind to open no matter what I do with Options, Trust Center Settings, et al.

Comment by: Jan Karel Pieterse (19-12-2021 11:48:00) deeplink to this comment

Hi Keith,


Comment by: Drew Smith (4-5-2022 19:58:00) deeplink to this comment

Followed all instructions, including checking regedit, but get an error message: Error 453: Can't find DLL entry point FindWindowA in user32 in modMain.FlexiFinder. Fails to load. Any suggestions, please?

Running Windows 10 BTW

Comment by: Jan Karel Pieterse (5-5-2022 10:27:00) deeplink to this comment

Hi Drew,

I've had one other report of this (for a different add-in), but we've never been able to resolve that matter. If it's OK, I'll send you a test version to see if we can resolve this.

Comment by: Jim Spielman (11-1-2023 16:18:00) deeplink to this comment

I have 18 workbook tabs with 9 graphs per tab. I need to move the data source forward one month each month, so the graph shows the month-by-month forward 12-month period line over the month-by-month trailing 12-month period line (esentially the monthly forward 12-month revenue forecast over the trailing 12-month actual revenue performance.

After each month-end close, How can I update these graphs (in bulk) so that the graph data is pulling from the new period ranges?

Comment by: Jan Karel Pieterse (11-1-2023 17:29:00) deeplink to this comment

Hi Jim,

I would do it like this:
- Insert a new blank sheet
- Add formulas to that sheet which fetch the data you need for each chart
- Make sure those formulas are dynamic: that they somehow allow you to select a period and that these formulas then pull the data from the right worksheets. You might want the INDIRECT function for that.
- Have the charts point to the formula ranges of this new sheet

If you set this up correctly, next time all it takes is choosing the right period on your newly inserted sheet.

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].