Lost data when saving excel as formatted text (.prn)

I can't. The worksheet was given to me as protected and it won't let me select the data to copy to a new workbook. On another machine, the same worksheet has everything visible, but on my machine there is data missing. What could be the problem with my machine?