ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save only Changes....Not complete workbook! (https://www.excelbanter.com/excel-programming/309691-save-only-changes-not-complete-workbook.html)

Celtic_Avenger[_21_]

Save only Changes....Not complete workbook!
 
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 entir
workbook? It would obviously save to the same file name. This would
presume then speed up the time required to perform the save operation!

Celtic_Avenger
:confused: :confused: :confused: :confused: :confused

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


Tom Ogilvy

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
:confused: :confused: :confused: :confused: :confused:


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




Celtic_Avenger[_23_]

Save only Changes....Not complete workbook!
 
I think I will therefore need to go down the line of splitting the larg
xls file into smaller ones with links.

Thanks

Celtic_Avenge

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



All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com