Ms access turn off screenupdating
For Win NT 4.0 you can get DKLITE (Executive Software) disk defragmentation for Win NT 4.0 (build 1381) free [ charge for non-network use). Results of running Diskeeper Lite (Free Version) after running over 24 hours: Diskeeper has completed a defragmentation run on this volume and there remain 22 fragmented files and/or directories and 99 excess fragments. A format in this case means each combination of font characteristics. Font type, font size, font color, interior color, bold, underline, pattern, number format, height, width, etc. Eliminating unused custom cell formats might also help.Documentation: NT 4.0 does not come with a defragmenter. (There were 1339 excess fragments before the defragmentation run, and now there are 92% less.) -- Picture of diskeeperlite result 78KB -- still looks like a mess. The practical limit may be about 3K rather than 4K mentioned in Q213904 -- XL Err Msg: "Too Many Different Cell Formats".If the file is accessed only in one version, you don’t want to use this feature.Save As a normal *file to eliminate the feature from your file.I frequently delete the files, but the surprise was that I thought I only had abour four single pages marked in favorites as “store offline”.So suggest also deleting the stored files occasionally to make sure that you are not storing documents you don’t want.
The general recommendation in the Excel groups (and MS KB Q167081) is to turn journaling off.I think if you have AOL, you will have to protect it by directory in your defragmenter.