{oapdf_gg}
1, the configuration of equipment is reasonable? In particular, Office 2003, it is indeed very powerful feature, but the corresponding hardware requirements also increased. General user system with Windows Xp, and then installed Office 2003, of course, other software, and this is the case, I recommend the configuration is: CPU P4 1G and above, 256MB memory and above, 40G hard drive and above. According to the configuration of your computer, you may also choose to install only some (but not necessarily all) Office components and tools. 2, add-in. Excel add-in built several procedures that can help us achieve a number of advanced features. In addition, we also can write their own, or the Internet can also find more of a wide variety of add-in program. In the use of add-in when I can give the proposal: First, add-in to confirm the validity of the source? After download and installation before the first anti-virus strongly recommended. Secondly, to use when re-load it, instead of all that has been all the add-in add-on. 3, automatic counting, automatic save option considerations. These two options to a certain extent, our work is made easier. However, in some cases (for example, is more time formula), especially the automatic recalculation may result in slower operation. Mentioned earlier: Auto-save option is a document may lead to a factor increases. Selectively operating a number of documents in the closure of these two options, the operating speed may be helpful. 4, iterative calculation of the consideration of options. For some special needs, we may allow for iterative calculation of the workbook, which is circular references (which have the purpose of the circular reference can be used in solution of simultaneous equations, such as some special occasions). But this circular reference will result in the calculation table frequently, when the worksheet changes in any place, on a re-calculation. Therefore, the impact of this is also one of the reasons for the speed of Excel. Application is not recommended on this option. 5, the document is not the normal (mainly the first part of this article referred to some cases). This solution will not repeat them. 6, inappropriate use of a number of other external tools may lead to problems. For example, some beta version of software, like the current VSTO 2005 BETA2, there are a number of targeted programming tools for Excel. Some friends (Please note: only that it might be) will find that after the installation of this tool, or even later, after unloading the tool, Excel document to read, especially the internal document macro very strange to "eat" memory, the specific is that Excel will frantically memory, which simply can not function properly. In these circumstances, there is a relatively easy way is to use: help => detect and repair, there are two options: Restore my shortcuts while repairing; abandon the custom settings and restore default settings. If both options are selected, or choose the second option, at least on the case, after the implementation of rehabilitation in general can solve the problem. Please note: Prior to the implementation of this operation, make sure you have made this operation may lead to some problems (for example, personal data files Outlook may need to specify: File will not be lost, but re-opened after repair Outlook before, go to control surfaces board => e-mail dialog box to specify your personal data files). Strongly suggest that you first read the corresponding help files. |