locked
Excel Powerpivot and R1C1 Reference Style RRS feed

  • Question

  • Setting Formula options in Excel 2010 to "R1C1 Reference Style" causes the Powerpivot add-in to have problems when creating slicers and report filters. Turning the "R1C1 Reference Style" off eliminates the problem.

     


    John Lacher
    • Moved by Max Meng Thursday, July 14, 2011 5:28 AM (From:Excel IT Pro Discussions)
    Tuesday, July 12, 2011 7:42 PM

Answers

  • Hi John,

    Have you tried to reinstall the Powerpivot add-in?


    Sincerely,

    Max Meng
    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, July 14, 2011 8:48 AM

All replies

  • Hi John,

    Have you tried to reinstall the Powerpivot add-in?


    Sincerely,

    Max Meng
    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, July 14, 2011 8:48 AM
  • John,

    Can be more specific as to what kind of problems you see?

    BTW, nice to hear from you.

    David Hager

    Monday, July 18, 2011 10:05 PM