Here is a post I saved on this topic...
:
The nature of a CD is such that Excel can't do its save process to it.
Excel first saves as a file with an internally generated name, then deletes
the original file, then renames the first file. This doesn't work with CD
drives. Save to a folder, then copy it to the CD and write the CD.