0 votes

A colleague suggested that FileLocatorPro can search inside cells in Excel to locate function calls. Can you tell me if this is true?

I have written a large number of custom functions that are used in hundreds of workbooks scattered all over my hard disk. From time to time, I have the need to enhance one of these functions requiring a change in syntax. I would like to be able to locate all workbooks that make use of this function so I can ensure that they continue to work properly.

If FLP can do this, please let me know if there is anything I need to know to make it work.
I am using Office 2007 on Windows XP and Office 2016 on Windows 10.


by (65 points)

1 Answer

0 votes

By default FileLocator Pro will try searching the 'text' of the spreadsheet, ie how it looks when you view it, but if you search the 'raw data' of the spreadsheet you should be able to search the underlying code.

To search the underlying data switch off the Office/PDF documents option and try again:

Switch Off Office processing

However, we no longer support Windows XP so this will only work with Windows Vista or higher.

by (31.3k points)