Open Software Solutions

When you try to create a simple cell link formula that refers to a cell in the data area of a PivotTable in Microsoft Excel, a GETPIVOTDATA formula is automatically created instead. CAUSE loadTOCNode(1, \'cause\'); This behavior occurs when the Generate GetPivotData setting on the PivotTable toolbar is turned on (enabled). This feature is enabled by default in Microsoft Excel 2002 and in Microsoft Office Excel 2003. This behavior also occurs when the Generate GetPivotData setting in the PivotTable group on the ... Read more..

SUMMARY loadTOCNode(1, \'summary\'); This article describes how to use the INDEX function to find data in a table at the intersection of a specific row and column in Microsoft Excel. There are two forms of the INDEX function, Array and Reference. The primary differences between the two forms are as follows: The Array form can return more than one value at a time. The Reference form returns the reference of the cell at the intersection of a particular ... Read more..

Description of the Excel 2007 hotfix package (Excel.msp, Oart.msp): August 26, 2008 View products that this article applies to.Article ID:956798Last Review:September 5, 2008Revision:1.1On This PageSUMMARYThis article describes the Microsoft Office Excel 2007 issue that is fixed in the hotfix package that is dated August 26, 2008.This article describes the following items about the hotfix:•The issues that the hotfix fixes.•The prerequisites for installing the hotfix.•Whether you must restart the computer after you install the hotfix.•Whether the hotfix is replaced by ... Read more..

When you open a file in Excel 2007, you receive a warning that the file format differs from the format that the file name extension specifiesView products that this article applies to.Article ID:948615Last Review:March 4, 2008Revision:1.1Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, ... Read more..

Data exported to a CSV file is formatted incorrectly in Excel on a computer that is running a localized non-Latin character based language version of Windows Server 2008View products that this article applies to.Article ID:954406Last Review:July 4, 2008Revision:1.0On This PageSYMPTOMSConsider the following scenario:•You export data from a snap-in in a localized version of Windows Server 2008 to create a Comma-Separated Values (CSV) file.•The localized version of Windows Server 2008 is a non-Latin character based language version.•You open the file ... Read more..

Description of the PerformancePoint Add-in for Excel performance improvements that are included in Cumulative Update 1 for PerformancePoint Server 2007View products that this article applies to.Article ID:949588Last Review:March 7, 2008Revision:1.0SUMMARYCumulative Update 1 for PerformancePoint Server 2007 improves performance in the PerformancePoint Add-in for Excel. Business applications that were created by using Planning Business Modeler will benefit from these performance improvements.Back to the topMORE INFORMATIONAfter you install Cumulative Update 1 for PerformancePoint Server 2007, you will notice ... Read more..

Description of the Word 2007 hotfix package: February 21, 2008View products that this article applies to.Article ID:948964Last Review:March 4, 2008Revision:1.0On This PageSUMMARYThis article describes the Microsoft Office Word 2007 issue that is fixed in the hotfix package that is dated February 21, 2008.Back to the topINTRODUCTIONIssue that the hotfix package fixesThis hotfix package fixes the following issue that is not previously documented in a Microsoft Knowledge Base article:•You attach an XML schema in the Templates and Add-ins dialog box in Word 2007. ... Read more..

MS08-014: Vulnerabilities in Microsoft Excel could allow remote code executionView products that this article applies to.Article ID:949029Last Review:March 19, 2008Revision:3.0On This PageINTRODUCTIONMicrosoft has released security bulletin MS08-014. This security bulletin contains all the relevant information about the security update. This includes file manifest information and deployment options. To view the complete security bulletin, visit one of the following Microsoft Web sites: •Home users:http://www.microsoft.com/protect/computer/updates/bulletins/200803.mspx (http://www.microsoft.com/protect/computer/updates/bulletins/200803.mspx)Skip the details:Download the updates for your home computer or for ... Read more..

Article ID: 968483 - Last Review: March 2, 2009 - Revision: 1.0Microsoft Office SharePoint Server 2007 unsupported scenarios using stsadm -o export /import of subsitesView products that this article applies to.Expand all | Collapse allSource: Microsoft SupportBack to the topRAPID PUBLISHINGRAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.Back to the topSymptomMicrosoft Office SharePoint Server ... Read more..

Description of Office 2008 for Mac Service Pack 1 (12.1.0)View products that this article applies to.Article ID:952331Last Review:May 13, 2008Revision:1.0On This PageSUMMARYMicrosoft has released security bulletin MS08-026. The security bulletin contains all the relevant information about the security update for Microsoft Office 2008 for Mac. To view the complete security bulletin, visit the following Microsoft Web sites: http://www.microsoft.com/technet/security/bulletin/ms08-026.mspx (http://www.microsoft.com/technet/security/bulletin/ms08-026.mspx)Back to the topUpdate detailsThe Office 2008 SP1 Update (12.1.0) contains several changes that improve security, stability, and performance. This includes fixes ... Read more..

Description of the Microsoft Office InfoPath 2007 hotfix package: April 15, 2008View products that this article applies to.Article ID:951440Last Review:April 18, 2008Revision:1.0On This PageSUMMARYThis article describes the Microsoft Office InfoPath 2007 issue that is fixed in the hotfix package that is dated April 15, 2008.This article describes the following items about the hotfix:•The issues that the hotfix fixes•The prerequisites for installing the hotfix•Whether you must restart the computer after you install the hotfix•Whether the hotfix is replaced by any ... Read more..

Description of the Word 2007 hotfix package: March 25, 2008View products that this article applies to.Article ID:950293Last Review:April 2, 2008Revision:1.0On This PageSUMMARYThis article describes the Microsoft Office Word 2007 issue that is fixed in the Word 2007 hotfix package that is dated March 25, 2008.This article describes the following items about the hotfix package:•The issues that the hotfix package fixes.•The prerequisites for installing the hotfix package.•Whether you must restart the computer after you install the hotfix package.•Whether the ... Read more..

Article ID: 956137 - Last Review: November 25, 2008 - Revision: 1.0Description of the Office Migration Planning Manager (OMPM) hotfix package (Offscan.exe): October 28, 2008Hotfix Download AvailableView and request hotfix downloadsView products that this article applies to.On This PageExpand all | Collapse allSUMMARYThis article describes the Office Migration Planning Manager issues that are fixed in the hotfix package that is dated October 28, 2008.This article describes the following items about the hotfix package:The issues that the hotfix package fixes.The prerequisites ... Read more..

In Microsoft Office Excel 2007, you open an .xls file that is located on a network share and then save it with a different name. When you do this, the modified date of the original .xls file is not reset to the original modified date and time as expected. Note This issue does not occur when the .xls file is located on a local disk or when the file has an ... Read more..

In Microsoft Excel, you can create conditional formatting on a cell or on a range of cells so that error values are not displayed in the cell(s). MORE INFORMATION loadTOCNode(1, \'moreinformation\'); In versions of Excel that are earlier than Microsoft Excel 97, you could not create a custom conditional format to hide error values that were returned to the cell by the cell formula. For example, #DIV/0! is returned to cell A1 if you enter the following data in the worksheet: ... Read more..

Article ID: 960534 - Last Review: December 17, 2008 - Revision: 1.0Description of the 2007 Office system hotfix package (Xmleditverb.msp): December 16, 2008Hotfix Download AvailableView and request hotfix downloadsView products that this article applies to.On This PageExpand all | Collapse allSUMMARYThis article describes the 2007 Microsoft Office system issue that is fixed in the hotfix package that is dated December 16, 2008.This article describes the following items about the hotfix package:The issues that the hotfix package fixes.The prerequisites for installing ... Read more..

Detection and deployment guidance for the August 12, 2008 security releaseView products that this article applies to.Article ID:956636Last Review:August 13, 2008Revision:2.0On This PageINTRODUCTIONAs part of an ongoing commitment to provide detection tools and deployment recommendations for security updates, Microsoft is delivering this detection and deployment guidance for all updates that are released during a Microsoft Security Response Center (MSRC) release cycle.This guidance contains recommendations that are based on the kinds of scenarios that may exist in various Microsoft operating system ... Read more..

The computer still prompts you to restart when you configure the Config.xml file to prevent the computer from restarting after you install the 2007 Office systemView products that this article applies to.Article ID:953366Last Review:June 2, 2008Revision:1.0SYMPTOMSYou configure the Config.xml file to prevent the computer from restarting after you install the 2007 Microsoft Office system. However, the computer still prompts you to restart. For example, you modify the following Setting Id element in the Config.xml file. <Setting ... Read more..

How to create a custom e-mail alert alert handler in Microsoft Office SharePoint Server View products that this article applies to.Article ID:948321Last Review:March 26, 2008Revision:1.1SUMMARYThis article describes how to create a custom e-mail alert handler in Microsoft Office SharePoint Server 2007. The method that is described in this article uses the IAlertNotificationHandler interface to intercept the e-mail alert and to modify it. You may want to create custom e-mail alert handler in Microsoft Office SharePoint Server 2007 in any of ... Read more..

Article ID: 968476 - Last Review: March 2, 2009 - Revision: 1.0'This List' scope not returning results on some lists, but returns when using 'This Site' scopeView products that this article applies to.Expand all | Collapse allSource: Microsoft SupportBack to the topRAPID PUBLISHINGRAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.Back to the topSymptomSearching for ... Read more..