ADVICE - on big excel programs & long save times

[Qroozn]

I have got a self created excel program... and found users hated having to wait 30 seconds fo it to save....
What i have now done is put a close button on the program index, and disabled the save on it unless they are logged in as ADMIN, and provided the password.

Now all variables the user enters are copied to an external DB. On autoopen of the program it opens the external DB and copies the info across to the program.

This means i can send a new program to users whenever there is an update and they dont lose any of their entries.

It now takes 2 seconds to close the program and save all the relevant details.(program is over 10 meg).

if a crash occurs due to size.. all the info has already been saved.

users can now run an export of a quote (they know it as a single row reference No.) and it can be imported on a national level.

I have also learnt to copy programs to a uniform location. e.g c:/program files.

[Tom Schreiner]

Thanks for the advice.
Have done similiar import/export stuff on a large spreadsheet to seperate files with good results...
Tom

[MarkHenri]

My customers have had good luck when they have copied the sheet to a new workbook, deleted the sheet, inserted the sheet and
copied the data back. Sometimes save times greatly improved.