You may notice that switching a form or datasheet to PivotTable view can take a long time. This is because a PivotTable view may slow down when it has to prepare a large volume of data.

You can do one or both of the following to improve the performance of a form or datasheet in PivotTable view:

• Base the view on only the data that you want to pivot

  A form or datasheet based on a large recordset can slow down significantly when in PivotTable view. If you are not interested in looking at the entire recordset, you can create a query that includes just the fields and records you are interested in, and then build a PivotTable view of the query.

• Hide details when not necessary

  When you are designing or using a PivotTable view, displaying only the aggregate values and keeping details hidden improves the view's performance. Show details for only the items you are interested in, and hide them when you are finished.