Vba open workbook without updating links


05-Nov-2017 12:30

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.



Take a former student of mine, Naoko, who worked as a programmer. “I just wore the same clothes, but on Sunday I’d go home for half a day, to shower. Sometimes I’ll ask my adult students how often they see their spouses, or ask the kids when they see their fathers.… continue reading »


Read more

If you follow the instructions I present here I can virtually guarantee your success with internet dating…It does matter what you look like or how much money you make or even what kind of car you drive.… continue reading »


Read more

She seemed to have a lot more faith than I could imagine. … continue reading »


Read more