I imported an Excel xls file with pivot tables and they don't refresh.

This is the error I get where the pivot tables should calculate in the cells.
#REF!

Please check field names first, maybe they include weird characters even everything is okay from MS Excel.