Imported Excel 2000 Tabbed Worksheet Printing Problems

[bkunkel]

We are just converting over to Oo.

On Excel 2000 files that have multiple tabbed worksheets and opening them in Oo we can't seem to select and print any other worksheet than the original first worksheet.

Tried saving as an calc file and then try to print...but that does not seem to work.

Anyone have a fix for this?

[richhill]

Take a look at Format -> Print Ranges -> Edit

I vaguely remember someone mentioning this before (perhaps it is a FAQ)
_________________
OOo Calc tips: http://www.openofficetips.com

[bkunkel]

Thanks,

You are correct...on both counts, there was some discussion on this subject under "print preview shows wrong tabs" and the solution is as you suggest.

Tried it and by defining the print area in each worksheet the both are able to be previewed and printed.

Thanks for the reply.

Regards,

bk