Saving only updated cells or worksheets

[Mark]

(This is the first time I'm using this feature - hopefully
I'm following the proper procedure!)

Is there a way, in Excel 2002, to only save the cells or
worksheets that have been updated, instead of saving the
entire file each time? I have a large file, with VBA code,
and is I could set it to only save the updated cells or
worksheets, this would decrease the time needed to save
the file. I read about Tools, Options and Allow Fast
Saves, but when I follow that path, there is no such
option to Allow Fast Saves.

Any assistance would be greatly appreciated!

Thank You,
MWS

 

[frank stone]

I am not sure that this can be done. when a file is saved,
the contends of memory is tranfered to the disk. i don't
believe i have ever heard of a feature call allow fast
saves. I may be wrong and i hope i am but i don't this
this feature exists.

 

[Dave Peterson]

Tools|Options|Save Tab|Allow Fast Saves
is an option in MSWord--not in excel.

And from what I've seen, a lot of people say not to use it in MSWord. I've read
posts that .doc files get corrupted more often with this turned on.

I don't use it.

 

[mws]

Thank You for the information Dave!

Is there anyway, that you are aware of, to expedite the
excel file "saving" process? The file I have contains
several worksheets, but only a few are updated by a user
at a time and having to save all the info that is
uneditted after each time the file is accessed takes a
considerable amount of time.

Any insight would be appreciated!!

 

[Dave Peterson]

With excel, you can save the workbook. You can't save each individual worksheet
and still have the whole workbook.

Lots of times, saving to a network drive is slow. Any chance you could copy the
workbook to the local drive, do your editting, save to that local drive, and
when you're done, copy the workbook back to the network location?