How to save an Excel file to CD

[spotit3]

I am sure I did this before but for the life of me I can't figure it out now. I am trying to write an Excel file to CD but seem to have forgotten how to. Any help would be appreciated.

[YvonneM]

I am sure you just go to SAVE AS and select where it says SAVE IN and select the appropriate drive

[elevenses]

I've just tried to do just that now, but with an incorrect function error code. I think you can only save direct to a CD if you have formatted it using Nero or another CD writer/Reader software package. Nero's one is called In CD.
One way of getting the file onto CD is to save it to your desktop and then right click the file and choose Send to ... and choose CD Drive. (If you have more than one CD writer or a CD writer and and a DVD writer make sure you have put a CD in the writer before choosing which drive.) Select the drive you want to send the file to and it will be placed into a tempory CD folder ready to be burned to CD when you're ready.
hope this helps or jogs your memory!