The File | Save Copy As command saves a copy of the active worksheet as a new file. Unlike with the Save As command, the newly created file is not opened in the current worksheet window. The original file remains in the worksheet window. Subsequent changes are performed on the original file that existed in the worksheet before the Save Copy As command was clicked.
When the File | Save As command is used, the original file is closed in the state in which it exists when the Save As command is clicked. The newly created file, with the new file name, type, and/or location is opened in the original file's place. Subsequent changes are performed on the newly created file.
In the example workflow on the left, the Save As command is used to save the active worksheet with a new
file name and type. The new file is then edited in the worksheet window. In the example workflow on the
right, the Save Copy As command is used to save a copy of the active worksheet with a new file name and
type. The original file is then edited in the worksheet window.
See Also