Re-calculating A Pivot Sheet

Sometimes, after changing your source records, a pivot sheet won't automatically reflect the current values. To worry! This is a quick and easy way to make sure that's accurate. You need to recalculate it. Often, you do this by selecting the "Refresh" option located in the "Data" area of the Ribbon. Besides, you could right-click directly on the re

read more