Excel Fast Save

[jswalsh33]

I am running Widow XP and Excel version 10.0.2614.0 and working with macro's.

Excel Help file refers to a "Allow fast Saves" check box on the Save tab of
the Tools menu, Options. There is no such a check box. Is there another way
to get fast saves or do I need a different version of Excel?

Also the macro cone Application.Calculation=x1Manual give a run time error.
Is this related to my version of Excel?

 

[JE McGimpsey]

You don't say which version you're using, and frankly, I don't remember
fast saves in XL, but you wouldn't want to use them anyway.

The way they worked in Word was to save only what changed from a base
version. Back when drives were slow, that saved time. The problem is
that it used to lead to corruption, and extra garbage in the file. Since
it appended data, it also usually was SLOWER than just saving the file
normally.

XL has long saved differently - saving a temporary file, deleting the
original, then renaming the temp file. No savings to be made by just
saving changes.

Your syntax error is from using a "one" instead of an "ell" in

xlManual

though the canonical constant to use is

xlCalculationManual

though in all current versions, at least, they're the same value.

 

[jswalsh33]

Thank you. That solved the problem of manual and automatic calculation.

On the fast save issue, I understand your answer. I have a large workbook
(30 MB) that takes 10's of seconds to complete a save. Since I would like to
save changes in my program on the fly, 10's of seconds is a long time when
executing a operator command. Is there any other way of shortening the save
time? For instance is there a macro code for saving the workbook
automatically on exit? In that way I would give up the saving on the fly.

 

[Shane Devenshire]

As was previous stated there is no Fast Save in Excel. You can speed things
up a little by:

1. Buying a faster hard drive 15,000 rpm.
2. Save to a flash drive
3. Save to a RAM disk
4. When you set Recalculation to Manual, uncheck the Recalculate before
save option.

 

[JE McGimpsey]

You could put this in your ThisWorkbook Code module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Save
End Sub