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

**clueless15** · 09-15-2012, 02:28 PM

When I save this excel sheet to formatted text (.prn), there are missing characters in the middle of each line. The last number of the first column and the whole fifth column is missing. Each line does not exceed 240 characters.

Also, this particular worksheet was given to me as protected so I cannot change cell width or anything.

I am using excel 2007 on a Windows XP machine. However, when I save the same sheet as formatted text (.prn) with excel 2007 on a Windows 7 machine, the data is complete. I need this to work on my Windows XP machine.

Any ideas on how to fix this problem?

**martindwilson** · 09-15-2012, 04:27 PM

what does it look like in print preview in xp? afaik it will only print what you can see,

**clueless15** · 09-17-2012, 06:00 AM

Hi martin. Thanks for your response. You're right. The missing data is also missing in print preview.

What could have caused this? The worksheet is using courier new font. How can I fix it?

**martindwilson** · 09-18-2012, 06:29 AM

as i said printing only prints what's visible so if you squash up a column and the text is not wrapped then only the visible text is printed.try copying the data to a new workbook and open up the columns

**clueless15** · 09-19-2012, 02:46 PM

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?