[Solved] All Sheets not showing in Page Preview

[steverd]

I have created a spreadsheet with 13 sheets. When I select all sheets and open the preview only 11 sheets are shown. Can someone get me going in right direction. I am familar with spreadsheets, most of my work was with MS Office. Now retired and cannot afford Office.

Thanks for any help. Using OpenOffice 3.3 on Win 7

[thomasjk]

The print preview is page based. Do you have a print range on each sheet? Use Format-->Print Ranges Define and under Tools-->Options-->Openoffice.org Calc-->Print Uncheck "Print only selected sheets".

[steverd]

Tom, Thanks for the response. This solved my problem. I did not remember setting the print range on the 11 sheets that would show, reset print range on all sheets and everything now works fine.

[jimbokea]

ok - got it - but it didn't help - but solved as in last reply.