Microsoft KB Archive/934236

= A Visual Studio 2005 Team Foundation Server list object becomes unusable when you turn off the Header Row option in Excel 2007 =

Article ID: 934236

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft Visual Studio 2005 Team Foundation Server
 * Microsoft Office Excel 2007

-



SYMPTOMS
Consider the following scenario. You turn off the Header Row option for a Microsoft Visual Studio 2005 Team Foundation Server list object in Microsoft Office Excel 2007. In this scenario, the list object becomes unusable. You must re-import the list object from Visual Studio 2005 Team Foundation Server to work on the list object.



CAUSE
This problem occurs because the Visual Studio 2005 Team Foundation Server list object relies heavily on the Header Row option being enabled. When you turn off the Header Row option, the list object cannot function correctly.



WORKAROUND
To work around this problem, enable the Header Row option for your Visual Studio 2005 Team Foundation Server list object. To do this, follow these steps:
 * 1) In Excel 2007, click the list object.
 * 2) Click the Design tab, and then click to select the Header Row check box.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem

 * 1) In Excel 2007, insert a Visual Studio 2005 Team Foundation Server list object into the worksheet.
 * 2) Click the Design tab, and then click to clear the Header Row check box.

Additional query words: list object TFS

Keywords: kbtshoot kbprb kbpubtypekc KB934236

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.