This is a tricky one

I am using a query to refresh another excel spreadsheet. This works perfectly but is excluding numerical values from the source sheet. Is this a problem with the source sheet as values in that are formula driven.