Excel formulas stop updating
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”.
The non existant z: drive left behind interferred with Save As process in ANY Office Application (like in Excel 2003) reported by Huvants Tuneau in email 2005-04-06.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".The program stops responding when you try to open the "Save In" list in Office 20, and you attempt to open the Save In list in the Save As dialog box, the program appears to stop responding (hangs) for a long time.If you click Cancel or attempt to close the Save As dialog box, the program still does not respond.Some specific tweaks for Excel 2003 (spinner 2005-04-08), appear to be the speech recognition above, no improvement in zooming graphics and fonts (keep zoom at 100%).
Auto Recovery is improved but you have to respond when Excel is going down, and decide which file (old or recovered) to use later but no peeking.
I think if you have AOL, you will have to protect it by directory in your defragmenter.
Since I lost AOL several times I think they have unmovable 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.
With a lot of stored file content and even though I had over 20GB free on my harddrive and 7GB for internet file, I could not view the source, or get into Front Page from IE except by deleting all temporary internet files "each" time I wanted to view the source. Defragmenter, with Win98 you get a defragmenter, with Win NT you will have to install one.
Please also include your version of Excel and Operating system if you did not originally provide that information.