Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print complete workbook Sharon Excel Discussion (Misc queries) 1 March 18th 09 10:19 PM
Can I apply a discount across a complete workbook? Pauliexjr Excel Worksheet Functions 2 January 27th 09 05:28 PM
number pages for complete workbook willeyc Excel Discussion (Misc queries) 1 October 18th 06 01:01 AM
same date and set up on complete workbook ED New Users to Excel 3 April 17th 06 04:22 PM
Unable to print a complete workbook Bradley Excel Discussion (Misc queries) 3 September 30th 05 02:57 PM


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"