Excel Powerpivot and R1C1 Reference Style

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

Answer 1

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.

Answer 2

John,

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

BTW, nice to hear from you.

David Hager