Nothing worked until I realised that most of the excel files being searched were the old format .xls. I upgraded them all to .xlsx and now search is reading the contents again no problem and returning the correct search results. Might be worth trying on a couple of your files to test? I upgraded around 5000 files to .xlsx and all is good again.