Pivot table not updating excel 2016

A formula must contain all of the required arguments, otherwise Excel displays ".So, whenever you are writing a formula for numerical values, follow this simple rule: don't enclose numbers in double quotes unless you want them to be treated as text.

Is my Excel corrupt or is this due to some malicious virus?There isn’t any setting the you can change, to make Excel automatically refresh a pivot table.To keep the pivot table up-to-date, you have 3 choices: Another way to update is to set the pivot table to refresh when you open the file that it’s in.For instance, instead of entering $50,000 in your formula, input simply 50000, and use the ) to format the output to your liking.

Numbers formatted as text values are another common reason for Excel formulas not working.

With this method, you’ll get partial automation, without having to add macros to the file.