I have a requirement from a business user that I don't know how to address. The question is this:
Can I count the number of times a specific value appears inside the spreadsheets stored in a SharePoint (MOSS Enterprise) document library? There are hundreds of complex spreadsheets in the library and the user wants to count the instances of a specific value in all spreadsheets stored in the library.
I can do all of the analytics that the user likes on the library metadata but I don't know where to start with this one. Thoughts?