We have been running datarefresh for about a year without problems. Last week one workbook suddenly stops working after refresh.
Some of the errormess are:
The workbook is messed up!
There are no errormess in the loggfile and the datarefresh says the it finished succesful.
If we do a manual datarefresh everything works OK. Below you see some of the message. Any ideas?
I solved it by renaming the the folder C:\Program Files\Microsoft Analysis Services\AS OLEDB\10 and Installing Powerpivot add-in again.