locked
refreshing from CSV without going into powerpivot window? RRS feed

  • Question

  • I am using a csv as a datasource for my powerpivot model.

    The "refresh Data" icon in excel on the Data tab does not refresh the data.
    If the CSV changes, i have to do the following to refresh the data:

    1. Open powerpivot window
    2. Click Refresh.


    Is there a way to refresh without going into the powerpivot window? ( i have users who i dont want going in there).

    Tuesday, August 12, 2014 2:34 PM

Answers

  • Unfortunately (or perhaps, fortunately), the Power Pivot implementation in 2013 was enhanced from 2010.  One of the changes enabled the refresh of the Power Pivot window contents directly from the Excel document.
    • Edited by Mark Weisman Tuesday, August 12, 2014 3:01 PM
    • Proposed as answer by Michael Amadi Sunday, September 14, 2014 11:37 AM
    • Marked as answer by Michael Amadi Tuesday, September 30, 2014 11:40 AM
    Tuesday, August 12, 2014 3:01 PM

All replies

  • Excel 2013 Power Pivot behaves as you would like.
    • Edited by Mark Weisman Tuesday, August 12, 2014 2:48 PM
    • Proposed as answer by Mark Weisman Tuesday, August 12, 2014 2:48 PM
    Tuesday, August 12, 2014 2:48 PM
  • I just performed a test of this in Excel 2013 and it worked. A few other things to consider - If you are using sharepoint you can set up an automated data refresh at intervals. When you are talking about making changes to the CSV, I assume you are talking about adding rows, not columns, right?
    Tuesday, August 12, 2014 2:50 PM
  • Hey Guys.

    Im trying to do this in 2010 (I should have mentioned that before).

    I am not using sharepoint.

    I tried importing the csv to a tab in the excel doc and then adding it as a linked table, but i get the error:
    The selected range is invalid. Select a valid range.(A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table.)

    Tuesday, August 12, 2014 2:57 PM
  • Unfortunately (or perhaps, fortunately), the Power Pivot implementation in 2013 was enhanced from 2010.  One of the changes enabled the refresh of the Power Pivot window contents directly from the Excel document.
    • Edited by Mark Weisman Tuesday, August 12, 2014 3:01 PM
    • Proposed as answer by Michael Amadi Sunday, September 14, 2014 11:37 AM
    • Marked as answer by Michael Amadi Tuesday, September 30, 2014 11:40 AM
    Tuesday, August 12, 2014 3:01 PM