Save only changes in a specific sheet, leave other sheets alone

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

PCLIVE

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.
 
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
 
Back
Top