Excel functions not auto updating

I work for a mortgage company, and more specifically I work for a VERY productive Loan Officer who simply cannot keep track of the sheer volume of product she is moving.I was asked to build a spreadsheet that could keep track of the loans.First of all I would like to say that your webpage has been invaluable to me.I've never had much use for excel prior to my current job and this site has been nothing short of a blessing.However, here is where the problems begin to raise their head.

But sometimes, you don’t want to change the range to table, and the above method is not available in Excel 2003 or earlier version.Supposing you have created a chart to track the daily sales based on a range of data in your workbook.But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.If this is set to manual, the formulas will not update unless you press the Calculate Now or Calculate Sheet buttons.Change it to Automatic and the formulas will start working.

Leave a Reply