X1 is Unable to Find Numbers in Excel Worksheets

By default, X1 is able to 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. When you install MS Office, a related IFilter for Excel should have also been installed. Telling X1 to use the MS Office IFilter may solve this issue.

To tell X1 to index your Excel files using an installed IFilter, perform these steps: 


1. In X1, go to Tools > Options > Files > More Indexing Options > Specify File Types 

Files_Indexing_Settings.png


2. In the "Additionally index all files with these extensions:" dialog, enter: XLS  

_53__Specify_File_Types_XLS.png

 

3. Click Close, then OK 



4. At this point, X1 needs to reindex the XLS files, so you've got a couple of options: 


     a. 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 

     b. 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 
 
     c. Clear and rebuild your index using Tools > Options > Indexing > Clear Index Files - note, that rebuilding includes  
            files + emails 


Once these XLS files have been reindexed, you may be able to perform searches against your Excel files that have cells formatted using the number/currency format (for example). 


Please note:
 Because there are different versions of the IFilter installed, the above instructions may not always work. 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk