View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Save only changes in a specific sheet, leave other sheets alone

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