VSOfficeDeveloper: Known Problems, Bugs, and Fixes

If you are working with a VSTO or managed code solution for Office, you may encounter a System.OutOfMemoryException when working with very large DataSets, XML files, or numerious object serialization calls. The problem typically occurs on a call to System...

You may encounter an OLE_E_CLASSDIFF (0x80040008) error on calls to OleRun or IOleObject::DoVerb when attempting to bind to a Word document saved as an OLE link by Word 2007. See the following post for details: OLE Link to Word 97-2003 File May Fail...

If you use a Cisco CSS switch for load balancing or content caching to a SharePoint Server farm, you may be unable to edit Office documents correctly if the switch is configured for Layer 5 content rules. By default, the Cisco CSS switch will block certain...

The Microsoft Excel 2007 XLL SDK introduced a new data structure, the XLOPER12, which allows your addin to obtain Unicode strings in XLL function calls. However, there were a couple of limitations with the implemention of the SDK which prevented your...

A problem was recently discovered with the Office 2007 Compatibility Pack file converters when used to open Office 2007 Open XML files in previous Office versions, when those files have custom Date/Time properties attached associated with SharePoint....

When publishing an InfoPath Form Template (XSN file) to multiple servers (i.e. a development server and a production server) and you are promoting fields from the InfoPath data source to be created as columns in SharePoint, those fields may get recreated...

The following post offers documentation on the Office 2007 MIME Types that can be used for HTTP content streaming to Office 2007 applications. Due to security measures in both IE and Office 2007, it is important that web sites return Office 2007 content...

The following error occurs when opening a read-only Visio Drawing from an ODMA Document Management System (DMS): An error (110) occurred during the action Open. Visio cannot write to the file. The file has been opened read-only. For full details...

ActiveX Controls used in Office applications with VBA must have at least their type library registered in the registry to work properly. VBA does not support Side-By-Side (SxS) registration of controls and this may prevent a control registered only by...

When calling ShellExecute to open an Office document from Internet Explorer, the call will fail with a “File not Found” error if Protected Mode is turned on. The problem occurs after installing Office 2007 Service Pack 1 on Windows Vista. For full...

When attempting to copy and paste OLE or OCX objects from Office applications running on a remote desktop to another application running on your local desktop, you may fail to get the data expected, or will find the data is unavailable from the Paste...

Managed addins/components that sink events on the Application object may cause problems with OLE functionality in that instance of Excel, resulting in errors or possible crash of host application trying to edit Excel embedded objects. Managed addins can...

XLL add-ins using the xlfGetDocument command to obtain shape data may fail in Excel 2007 because a known problem in that version. The bug is being investigated for a fix in a future Excel release. See the following post for more details: Excel 2007...

Office 2007 introduces a new save behavior for ActiveX Controls (OCX) saved directly in Word, Excel, and PowerPoint documents. As part of the new Open XML file format, OCX controls can be persisted as XML data if the control supports saving by IPersistPropertyBag...

Description of the Microsoft Office Existence Discovery Protocol, which is new to Office 2007....

Web sites that use an XLS MIME type to open content in Excel 2007 from a web site may see warning alert that file is in a different format than its extension. This is a new alert to Excel 2007. The reason for the alert, and things you can do to work around it, are documented in this post....

Users often send documents to each other as Outlook attachments. Depending on how the attachments are opened from Outlook, they may even be editable, so the attachment can be edited and then forwarded to another recipient. However, users with InfoPath...

Developers working with Microsoft Office files can now freely download he specifications for both the Office 2007 Open Office XML (OOXML) Formats and the older Office 97-2003 Binary File Formats (BIFF), for Word/Excel/PowerPoint. Microsoft has agreed...

Managed code exported via COM Interop may not load correctly inside of Word or Excel VBA if the assemblies were written for the .NET 2.0 Framework. There is a policy that locks back the CLR to versions 1.0/1.1 for Word and Excel, unless the client updates...

ActiveX controls saved in Office 2007 using the IPersistPropertyBag interface may encounter alterations to strings they save to the property bag. This occurs because the strings are persisted in the XML and must conform to XML syntax rules, which can...

When using OLE 1.0 objects in Word, you may experience problems in getting the presentation metafile (WMF) to update correctly if the document is not saved first. This problem occurs only with OLE 1.0 objects and not OLE 2.0. See this page for the...