However, there are some other parameters that can be set at the same time. For other options, simply choose the Advanced tab. There are three core parameters that you need to be aware of. The first is the length of time you will store the history in your file. Microsoft Excel allows you to store over 32000 days worth of changes to your Excel file, however, there is a catch. All of that information is stored in your file and consequently your file will grow exponentially. Most organisations generally work on a maximum of 30 days and that is the default, however the value entered simply depends on your workbooks requirements. You can choose the second option which says, Don‘t Keep Change History. This simply ensures no changes are maintained.
When you write your formula, you will see that any x symbols show up in formula script. That means no extra formatting is required between typing the formula and publishing the completed work. This is ideal if you‘ve ever wanted to label a chart with its mathematical formula. The only caveat to add to all the above is that your freshly written equation will appear in a textbox. Textboxes are distinct from the main spreadsheet in that they have no cell address. This means they can be dragged across the sheet to your desired location. Obviously you don‘t want to have to move the formula every time you insert or delete rows from the underlying spreadsheet. Fortunately the default settings for such objects ensure that they retain their local position at all times.