locked
getting started with PowerPivot RRS feed

  • Question

  • Hi.  In excel 2007 when we pivot olap data, the accidental entry by a user into a data cell of some character or number prevents refresh of that cell from the cube forever.  When I get excel 2010 and Power Pivot installed, will I find that this doesnt happen anymore?

    • Edited by db042188 Friday, August 5, 2011 4:22 PM clarity
    Friday, August 5, 2011 1:35 PM

Answers

  • it looks like you cannot type into the special power pivot window cells like you can in a normal workbook with a db connection.  This is good news as I've always considered this the biggest roadblock to giving our users excel spreadsheet reports that refresh on open.
    • Marked as answer by db042188 Sunday, August 7, 2011 3:24 PM
    Sunday, August 7, 2011 3:24 PM