Single Class document in Syntex - Excel value

Hi

I'm trying to build a model using the Single Class document and then read Excel files from a SharePoint library. It reads most of the data except cells which has a value from a formula or reference! 

So if A2 has the value 5, i see it in the data read, if B2 has the value =sum(a2+a3) = 6 it does not show in the data output from the file.

Any idea how to get around this? I have roughly 120 new Excel files each month, Ineed to compile into one CSV - whilst waiting for a proper business system ;-)