Formulas in are turning into values for no reason
 

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.

Formulas in are turning into values for no reason
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steve" wrote in message
...
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.