|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.|
How to: Work Offline in Microsoft Excel
You can work on work items in Microsoft Excel offline, and then reconnect to Team Foundation Server to publish your changes.
When you are working offline, Microsoft Excel will not warn you if you enter values that are not supported. For example, in the MSF for Agile Software Development process, when a bug is active, it can only move to the resolved state. When you are working offline, Microsoft Excel allows you to set an active bug to closed, and you receive a validation error when you publish your changes.
To perform these procedures, you must be a member of the Contributors group or have the View work items in this node and Edit work items in this node permissions set to Allow. For more information, see.
To work on a work item list offline
Create or open the work item list that you want to work on offline. For more information, see.
Refresh the work item list to ensure that you have the latest information. For more information, see.
Disconnect your computer from the network, or copy the work item list file to another computer that is not connected to Team Foundation Server.
You may receive an error message indicating that a connection with Team Foundation Server could not be established.
Make changes to the work item list as needed. For information on reconnecting the work item list, see the procedure "To reconnect a work item list after working offline."
To reconnect a work item list after working offline
Reconnect your computer to the network, or copy the work item list file back to a computer that is connected to Team Foundation Server. For more information, see.
Publish the work item list. For more information, see.
If there are data validation errors or conflicts, resolve them. For more information, seeand .