I have a workbook where I may update information on a specific sheet and
then on another sheet I may have made some modifications that I do not want
to keep.

Is there a way to update a file saving only the changes in a worksheet that
I specify and not save anything else from other sheets in the workbook?
Basically, the other worksheets in the file would remain unchanged, but the
specific sheet would be saved or updated in the file.

Is there a way to do this?

Thanks,
Paul

--

Excel saves the entire workbook--not specific sheets.

So don't make changes you don't want to save or change them back or don't save
the workbook.



PCLIVE wrote:

I have a workbook where I may update information on a specific sheet and
then on another sheet I may have made some modifications that I do not want
to keep.

Is there a way to update a file saving only the changes in a worksheet that
I specify and not save anything else from other sheets in the workbook?
Basically, the other worksheets in the file would remain unchanged, but the
specific sheet would be saved or updated in the file.

Is there a way to do this?

Thanks,
Paul

--


--

Dave Peterson

The only alternitive to what Dave said will be to use the SaveAs method of
the Worksheet object which will save the specified sheet as a stand alone
File

"PCLIVE" wrote in message
...
I have a workbook where I may update information on a specific sheet and
then on another sheet I may have made some modifications that I do not want
to keep.

Is there a way to update a file saving only the changes in a worksheet
that I specify and not save anything else from other sheets in the
workbook? Basically, the other worksheets in the file would remain
unchanged, but the specific sheet would be saved or updated in the file.

Is there a way to do this?

Thanks,
Paul

--