Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Do PivotTables update automatically when the source data changes?

  1. A Yes, immediately
  2. B No, they must be refreshed
  3. C Only on file open
  4. D Only if the source is a Table
Answer

No, they must be refreshed

Stale PivotTables showing old numbers is a common source of reporting errors. Basing them on an Excel Table at least keeps the range correct.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as