Formulas in are turning into values for no reason

S

Steve

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.
 
B

Bernard Liengme

Using CTRL+` (the key next to 1 on top row of keyboard) causes worksheet to
display formulas; press these keys again to go back to values.
best wishes
 
Top