Vba open workbook without updating links
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.Windows 98 has a utility that will help with many of the above it is called Disk Clean Up and can be found in Programs, Accessories, Utilities from your Windows START button.Like much of MS software it does not tell you what it is going to do before it starts.Fortunately it just initially calculates how much space you would save by checking certain code lines to delete files and only deletes those types of files when you give it permission to delete all of them.C:\WINNT\PROFILES\userid\Temporary Internet Files From Internet Explorer, Tools, Internet Options, General (tab), Delete files.
The general recommendation in the Excel groups (and MS KB Q167081) is to turn journaling off.
Example using XL2000, my 2.16MB file was saved as a 3.85MB file and took 45 seconds to save first time with Save As, and over one minute with subsequent Save.
The save time for this large file as a normal XL2000 file is 10 seconds. If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *you will see the following Microsoft Excel 5.0/7.0 saving on your status bar where you normally see Ready toward the end of the save then you are saving in multiple formats.
After clearing out everything imaginable and having been running 190-250MB for a month, I thought I'd clear out the “stored offline” files -- I suddenly had 900MB of free space.
Afterwards I went to Favorites, then organize, and used the Arrow DN key to check each exposed folder and single files.
And to think I massacred a bunch of newsgroups to gain a few MB of storage here and there, but if I really needed them I suppose I wouldn’t have deleted those newsgroups.