View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Save only Changes....Not complete workbook!

There is no option like this. In fact, while working with a file in Excel,
you are working on a copy of the file. If you close without saving, this
file is discarded. If you save, then the original file is destroyed and
this copy with the changes is renamed.

--
Regards,
Tom Ogilvy


"Celtic_Avenger " wrote in
message ...
Is it possible to set a code in a very large spreadsheet (6MB or more)
to save only the changes made to the book, rather than the entire
workbook? It would obviously save to the same file name. This would I
presume then speed up the time required to perform the save operation!

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/