You may receive an error message when you try to modify a workbook that is under source code control in Visual Studio 2005 Tools for Office (908430)

SYMPTOMS

When you try to modify a workbook that is under source code control in a Microsoft Visual Studio 2005 Tools for the Microsoft Office System project, your modifications may not be retained. Also, you may receive an error message that is similar to the following:

Source Code Control Synchronization
In order to complete the requested synchronization operation, the document must be closed and reopened. All your recent changes will be lost."

WORKAROUND

To work around this problem, check out the workbook from source code control before you modify the workbook.

MORE INFORMATION

Steps to reproduce the behavior

Create a new Visual Studio Tools for Office Excel Workbook project.
On the Project menu, click Source Control, and then click Add Solution to Source Control.
Check in all documents to the source code control server.
In the Microsoft Visual Studio designer, open Sheet1 in the project that you created in step 1.
Make a change to Sheet1, and then press Enter. You receive the source code control synchronization error message, and your modifications are not retained.