This is odd. I have a pivot table and whenever I reference to it, it just stays a formula (e.g., "=B47" and enter just stays "=B47"). Within the pivot table, I've turned off "Generate Get Pivot Data" so that it refers to the cells as normal.
Calculation is absolutely turned to automatic. The cell is formatted as a number.
I mention this cell formatting because my first thought was that it sees it as text. When this happens, I change the format to a number, press enter, and I'm good. Not so here.
I'm afraid I have no idea as to what's happening.
Your help is appreciated.
Calculation is absolutely turned to automatic. The cell is formatted as a number.
I mention this cell formatting because my first thought was that it sees it as text. When this happens, I change the format to a number, press enter, and I'm good. Not so here.
I'm afraid I have no idea as to what's happening.
Your help is appreciated.
