Can't refresh connections when I have both Analysis Service and Excel Spreadsheet

[Kalle123]

Hi Everyone!

I have made a report using PowerPivot and have connections to both Analysis Services and Excel Spreadsheet (the same spreadsheet that is the file). My colleagues have now starting to use the report and they are refreshing the data and everything is OK expect for one colleague. She can't refresh both the Analysis Services and the Excel spreadsheet connections at the same time (by using Refresh All) and it seems like it is the Excel Spreadsheet that is causing the problem. She can refresh Analysis Services if she only refresh that connection but she can't refresh the Excel file connection. So the file work for 9 out of 10 persons. We have the same computers and the same type of programs installed in the machine. Our IT-department has had the case for over a month but they can't solve it. Do you guys have an idées of what the problem can be?

Thanks in advance!

 

[Matt Allington]

When you say "same spreadsheet", do you mean it is a linked table? What version of Excel? Have you checked all the shared software like .Net framework and Access Jet Engine etc?