• Email : info@istep.fr

Blog et publications d'iStep

Restez informé !

Le blog d'istep

SharePoint Online / Office 365 search engine can't index Excel files bigger than 3 MB !!!

SharePoint Online / Office 365 search engine can't index Excel files bigger than 3 MB !!!

 

SharePoint Online / Office 365 search engine can't index Excel files bigger than 3 MB !!!

I recently discover a huge limitation on SharePoint Online Search engine.

Please take a seat : SharePoint Online Search engine can't index content of excel files if files are bigger than 3 MB !!!!  (not 30MB, nor 300MB, but yes 3 MB !!!!!!!)

For example if your excel workbook is a 4Mb file, the only things which will be crawled are metadata : Title, File name .....

This limitation is very strange : note that this limit is only on excel file, if your document is a Word (.docx) PDF (.pdf) , ... content is crawled until 64 MB which is honnestly a good size for an office file.

 

How to fix it ? Sadly i had to suggest to my customer to cut his workbooks in separated files smaller than 3MB ..... and wow it's magic, content is crawled :'(

 

Search limits for SharePoint Online [ Official Office Support ]

https://support.office.com/en-au/article/Search-limits-for-SharePoint-Online-7c06e9ed-98b6-4304-a900-14773a8fa32f

 

 

 

 

 

Catégories: Publications, Articles Techniques (Knowledge Base)

Comments

  • Is there same limitation with eDiscovery center ? I'll check in Power BI regarding pure Excel content. But I can say that Q&A Model indexation and search do not have this kind of limitation 😉 Enough of joking, do you have any technical explication ?
    02/06/2015 19:09:35 Reply
    • @Jean-Pierre Riehl: :) Not sure, maybe something with the old school limitation in .xls files which was 65000 lines wich cost approximatively 3Mb.
      05/06/2015 09:08:49 Reply

Post a Comment

Recherche Blog
Historique