Do You Get This Error From Time to Time in Excel 2010? I Do. And it’s Quite Fixable.
This morning, when I loaded up my workbook from last Thursday to start today’s blog post, I got this error.
For awhile now I’ve been meaning to post that this is very “fixable.”
When I opened the workbook, I had a cell in the pivot selected:
To make the error go away:
- Click OK.
- Select a cell outside of the pivot
- Now select a cell inside the pivot again
- Usually the error goes away
Just click OK, Select a Cell Outside the Pivot, Then Select Back Inside the Pivot