Cannot update any connections onto Excel files... RRS feed

  • General discussion

  • Hi,

    I have the latest build of PowerPivot for Excel (build 11.0.2100.60).

    I have built a model with about 5 tables from different Excel files. The model has worked fine for about 2 weeks.

    Right now, I cannot update any of the connections from the Excel files, nor create new ones on Excel files neither... I get an ODBC unknow error while trying to refresh data or generate a new connection on Excel files...

    I also have a connection to an Oracle database wich is updating fine, so I am leaning towards a problem with the data access components that are used to connect onto Excel files... Is there any way to reset the components, or repair any corruption that could have occured into the PowerPivot model?

    The last thing I want to do is regenerate the model each time that kind of error occurs...
    Tuesday, July 10, 2012 3:36 PM

All replies