Describe how you can have Excel refresh your PivotTable automatically when you open the workbook in which it is contained.
What will be an ideal response?
If you want Excel to refresh your PivotTable report automatically when you open the workbook in which it is contained, click the Options button in the PivotTable group, click the Data tab in the PivotTable Options dialog box, click the Refresh data when opening the file check box, then click OK.
You might also like to view...
The values stored in an array are called the array's ____.
A. indices B. items C. nodes D. types
A queue is a container that allows elements to be stored and removed
A) in a last-in-first-out fashion B) in a first-in-first-out fashion C) in a first-in-last-out fashion D) quickly and efficiently
The Performance Diagnostics Report is a pre-built report that contains an easy to understand summary of a computer's overall performance
Indicate whether the statement is true or false
One nice aspect of DSL is that you do not have to run new phone lines.
Answer the following statement true (T) or false (F)