William Case wrote:
Hi;
This may just be a brain cramp, but I can't see anything in help. If it
is in help could you tell me under which topic I should be looking.
I have a big spreadsheet in Calc with several sheets. I simply want to
save one sheet to a new file (.xls). The data and calculations on this
sheet are Independent of all other sheets.
Is there a way to do this without coping the entire sheet to a brand new
Calc file?
Using OOO 3.3.0
It is quite easy to do. Right click on the sheet you want to copy,
select the Move/Copy option. In the pop-up, at the top, where it says
"To document" select new. If you wish to copy the page click the box at
the bottom that says "Copy". This will create a new file with only that
sheet copied. Open that file and then Save As to the .xls format.
HTH
Andy
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help