In the process of using Excel, if some formulas involved in the data table are slightly inadvertent, the input will be confused. So what should I do if I encounter this situation? The following system home Xiaobian tells you how to use the temporary hidden table to protect data security. A new recruit from a company is responsible for entering product data. After retrieving the entered Excel spreadsheet file, the product manager found that the calculation of the price column in the table for several people was incorrect. Later, the analysis found that it was originally because these employees accidentally moved the formula in the form during the entry process. Tip: In Excel worksheets, in order to improve calculation and work efficiency, designers often use some functions or calculation formulas composed of functions and numbers. However, users do not necessarily understand this. For those who don't understand formulas or functions, it's easy to get a formula or function that someone else has designed in the process of working with a form. In the end, you can't figure out the correct result, but you don't know why. Even those who have learned a function or formula, if they accidentally destroy a formula or expression designed by someone else, to restore it to its original appearance, they have to ponder for a long time. Therefore, it is important to protect these functions or formulas. Borrowing temporary tables to implement formula transfer ideas: Since formulas or expressions are easy to be broken by users in conspicuous places, why not put them in a hidden place (such as another worksheet or even another workbook file) It is not necessary to quote only a simple cell address when using it! We can use this method for worksheets involving more formulas or for constructing more complex formulas. We can also put some constant values, list data, temporary variables in the calculation, etc., in a temporary work table to facilitate the call. For example: the formula that appears in Sheet1, now we are afraid of the user messing up, in order to protect it, you can store it in another table Sheet2. In order to construct the formula, we need to create a new worksheet Sheet2 in the current workbook. In the A1 cell of this table, construct the formula needed for the calculation. Thereafter, no matter how complex the function expression in the A1 cell, we can use the simple expression =Sheet2!A1 to call the calculation result in any cell of any worksheet in this workbook (Figure 1 ). For fixed parameter migration and reuse, we can even put the formula in another Excel file (such as Book2), and then use the format =[Book2]Sheet2!A1 to achieve fast call. Here, Book2 represents another Excel workbook file in the same folder, Sheet2 is the table in the file, and A1 is the cell in the table. If the Excel file that holds the formula is not in the same folder as the working file, you need to add a path to form an expression like =[C:\\Documents and Settings\\aaa\\Desktop\\Book2]Sheet2!A1. Hiding Temporary Tables Ensuring Data Security Perhaps you might think that in order to calculate some results, you can design a worksheet or even a workbook file to get in the way. Don't worry! This problem is solved. After the temporary worksheet is created and the formula is built, if the temporary worksheet is hidden, it will not affect the aesthetics and convenience of the overall form. To do this, click on the worksheet label containing the formula, switch the worksheet to the current worksheet, and then select the “format →worksheet →hide” command to hide the currently displayed worksheet ( figure 2). In this way, because the operation does not directly touch the formula or expression, it is much safer. Tip: Conversely, when you analyze a form made by someone else and find a worksheet that you can't see, you can try “format →table →unhide” command, you may find A worksheet with a formula. This article comes from [System Home] www.xp85.com