Someone in my department opened a file that should have had numerous
GETPIVOTDATA formulas in it and all the formulas were showing up as values.
I opened the same file right after her and the formulas were back in the
spreadsheet. No one else has access to the file. I know you can copy and
paste values, but neither of us did that. How can the file miraculously
change from values back to the proper formulas.