About improving Datasheet view performance

Microsoft Datasheet View

About improving Datasheet view performance

The performance of a Datasheet view depends on many factors, such as the size of the list, performance and configuration of the server, and network conditions. This topic lists a few guidelines for improving view performance.

The following operations might take some time to complete, so keep them to the minimum:

  • Refreshing a view that contains a large amount of data.
  • Moving or copying large sets of data.
  • Filling large numbers of cells by dragging the fill handle.
  • Changing the formula in a calculated column.
  • Attaching large documents.
  • Exporting from and linking to Microsoft Office Excel.
  • Resolving large numbers of errors.

Do the following to improve performance of a view:

  • Remove unnecessary columns from the view. In the Edit Datasheet View page, clear the Display check box for columns that are not necessary in the view. But do not remove columns that are marked Required. You will not be able to add data if the view does not include all required columns.
  • Apply one or more filters to remove rows that are not necessary. For example, you could edit the definition of the Managers view to include a filter that hides rows of employeers who are not managers.

    In addition to saved filters, you could apply filters during a session to further reduce the amount of data in the view. For example, if you are currently updating rows of managers in Washington, hide the rows of managers from other states.

  • Configure the SharePoint server to improve performance. For more information on improving server performance, see Microsoft Windows SharePoint Services Help. To display Windows SharePoint Services Help, click Help on the page toolbar.