Using odc file in PowerPivot Model


  • Hi everybody,

    Is there a way to use an odc file to get data into a PowerPivot Model?
    I want to be able to get data from an odc file which is stored on Sharepoint



    Tuesday, October 22, 2013 9:13 AM


  • Hi Pete,

    Absolutely. Please refer to the following steps to use .odc file to import data to PowerPivot model:

    1. Click "Manage" button to open PowerPivot model dialog box.
    2. Click the "Existing Connections" button.
    3. Click "Browse for more" button to select your .odc file.
    4. Click "Open".

    Then, please follow the "Table Import Wizard" to import data to PowerPivot model. For more information about data sources supported in PowerPivot Workbooks, please see the article below:


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    Thursday, October 24, 2013 12:23 PM