Here is the word, slightly edited, "from the horse's mouth":
In its default state, X1 can index Excel files that have cells formatted using the general format and not cells that have been formatted using the number or currency format (for example).
However, X1 has the ability to utilize IFilters. Installing MS Office, should also install a related IFilter for Excel. Telling X1 to use the MS Office IFilter may solve this issue; however, because there are different versions of the IFilter installed, this solution may not always work.
This is the IFilter in question and its location:
c:\windows\system32\offfilt.dll
(X1 users have reported finding various versions of offfilt.dll)
To tell X1 to index your Excel files using the installed iFilter, perform these steps:
<OL><LI>In X1, go to Tools > Options > Files > More Indexing Options > Specify File Types
<LI>In the "Additionally index all files with these extensions:" dialog, enter: XLS
<LI>Click Close, Close then OK
<LI>At this point, X1 needs to reindex the XLS files, so you've got several options:
- 4a. Move the applicable files to a new/different folder and update your file index; move the files back to the original folder and update your file index a second time
OR
- 4b. Rename the folder(s) where these XLS files reside and update your file index; rename the folder back to the original and update your file index a second time
OR
- 4c. Clear and rebuild your index - note, that rebuilding include files + emails
</OL>
Once these XLS files have been reindexed, you should then be able to perform searches against your Excel files that have cells formatted using the number/currency format (for example).
Please note: you must be running build 3377 or higher of X1 for these steps to work
As usual, please provide any feedback on whether this works for you. And feel free to suggest improvements or new ways of achieving the same task.
