PDA

View Full Version : Excel 2010 Print Blank Page



joms
07-31-2013, 11:36 PM
hi guys, anyone encounter this problem before. please help to shed some ideas on how to solve.

i had this excel file which was in 2003 format and was saved as excel 2010 file.

It has 4 worksheets has a lot of data and works very slow now.

but when i click on print preview on some worksheet there's nothing.

And i continue printing it will print nothing. But worksheet has a lot of data.

I had checked the formulas there is no errors.

Like sheet1 to sheet3 - no print preview and print blank page

Sheet4 - is the only worksheet that prints okay

sheet1 to sheet3 has a lot of data.

please help guys. thanks.

joms
08-01-2013, 03:16 AM
just for update, found the solution from this link: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx

save the file to a SYLK (Symbolic Link) and save it back to a normal workbook and works fine.

but i'm not sure what cause the corruption of the file. it could be directly saving the 2003 format to 2010.

I should first converted to 2007 then use the file as 2010.