Excel 2007 Service Pack 2 - the official fix list

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Official fix list for Excel 2007 SP2 both the summary and the complete list

Here’s the official fix list for Excel 2007 SP2 both the summary and the complete list. We’ve published it here for easy reference instead of hunting around Microsoft’s web site and an Excel worksheet.

This list does NOT include details of past hotfixes, security and other updates that are also bundled into Service Pack 2.

The list isn’t complete – Microsoft says there are other reliability, security and what they feel are minor bugs they consider ‘too specific’ to be publicly disclosed.


Excel 2007


Summary



  • Improves the charting mechanism in Excel 2007. This includes better parity with Office 2003, improved robustness, and targeted performance improvements.
  • Adds a chart object model to Word and to PowerPoint.
  • Improves shapes that are surfaced in Excel. This includes better parity with Office 2003 and targeted performance improvements.
  • Improves the method by which Excel prints graphical content, especially when it prints to PCL printers.
  • Adds conversion rates to the Excel Euro Currency Tools add-in for the Maltese lira and for the Cypriot pound.

File formats



  • OpenDocument Format (ODF) support
    SP2 lets you open, edit, and save documents in version 1.1 of the ODF forWord, forExcel, and forPowerPoint. Users of these Office programs can now open, edit, and save files in the OpenDocument Text (*.odt), OpenDocument Spreadsheet (*.ods), and OpenDocument Presentations (*.odp) formats.
  • Extensible file formats
    Extensible File Formats: Word, Excel, and PowerPoint now include a converter interface that lets you plug third-party custom file formats into these Office programs. A developer can create a converter for files of a particular extension. When this converter is installed on a user’s computer, the custom file format effectively behaves like a built-in file format. Specifically, users can open files of this format and save them by using the Open or Save UI. They can even set the custom format as their default file format. For more information, visit the following MSDN Web site:
    http://msdn.microsoft.com/en-us/library/dd300649.aspx
  • Built-in Save As PDF/XPS support
    PDF/XPS support is built into SP2 for Word, for Excel, and for PowerPoint. Users no longer have to download the add-in separately. 

 


Complete list

Under ‘Office Graphics’ (not Excel) there’s a mention of:




  • When you paste a chart from Excel into Word or PowerPoint, shapes on the chart that contain text links to cell values are lost.

that we can’t see in the full list of Excel 2007 SP2 fixes:



  • “Remove Duplicates” on a range of cells misses some duplicate string values.
  • 3D shading on surface charts is lost when you save the file as an .xls file.
  • A “#REF!” error appears in a formula with a cross-sheet reference in a workbook protected by a “no extract” DRM permission.
  • A chart that you created in Excel 2003 and that includes a data table does not show the entire table when you open the chart in Excel 2007.
  • A number entered with the Taiwan currency symbol is not recognized as a number and ends up as a string value.
  • A query table range is lost after you delete the query table and then undo the deletion.
  • A run-time exception occurs when you run the ErrorBar command through the object model and only one value is specified.
  • A shape’s position on a chart is not saved correctly when you save as an .xls file using Excel 2007. The shape appears in a different position when you open the file in Excel 2003.
  • A text box is resized, and the font zooms in after OLE chart activation.
  • Adding cube functions using the data connection of a PivotTable connected to an offline (local) cube causes Excel to hang.
  • AddPeriods, RemovePeriods and Find do not work on chart TextElements.
  • After running a macro that opens the Find/Replace dialog programmatically, users cannot open the Find/Replace dialog from the ribbon UI.
  • An ActiveX control, such as a TextBox, may not retain its modified name after you save and reopen the workbook.
  • An Excel 2007 binary workbook has defined names that use both an English version and a local version of a built-in name (such as “database”). When you load this Excel 2007 binary workbook in a non-US-English version of Excel, the English name is removed. Additionally, all the formulas that refer to it now refer to the local name.
  • An Excel chart, embedded as an OLE object in a PowerPoint 2007 presentation saved as a PPT file, changes size when it is subsequently activated in PowerPoint 2003.
  • Applying a template to an already created chart in Word or PowerPoint causes the data to disappear.
  • Applying and switching between custom chart templates causes a crash in PowerPoint and Word.
  • AutoComplete fails in the CUBEMEMBER function for a member name that includes quotation marks, and a user cannot access the children of that member by using AutoComplete.
  • Autoconversion in the Euro tool does not work when another workbook or add-in has methods with names that are identical to the autoconversion code.
  • AutoSave does not work in Excel 2007 when the default save file format is XLS. In the case of a crash, nothing is recovered.
  • Bar and Column charts that have some very small positive values relative to other values may appear as very small negative values.
  • Calls from an xlsx workbook to a user-defined function in an XLL add-in returns a “#NAME!” error when the workbook is opened in a previous version of Excel through the compatibility pack.
  • Changes to graphical objects will not be reflected in cameras of the object(s) if the camera object and the graphical object(s) are on different worksheets.
  • Chart animation (redraws) is slower when a part of the chart was selected prior to starting the animation code.
  • Chart elements can be moved and resized on a protected chart sheet.
  • Chart gridlines and tick marks do not always align correctly.
  • Chart templates cannot be set as the default chart type for chart insertion.
  • Charts inserted without data do not retain all formatting properties when data is eventually added to the chart.
  • Charts or shapes can be resized and moved on a protected chart sheet.
  • Charts that use named ranges for the series name and value are not updated correctly.
  • Charts, shapes, and SmartArt objects flicker when they are selected in Page Layout view.
  • Copy a worksheet with a timescale chart with a custom major unit type to a new workbook. The newly copied chart no longer has the custom major unit type.
  • Copying and pasting connector shapes into Excel 2007 can result in the connectors being rotated or disconnected.
  • Creating an Analysis Toolpack chart on the last sheet (in alphabetical order) in a workbook with a Unicode name crashes Excel.
  • Creating certain PivotTables with multiple fields on the row axis in VBA code causes Excel to crash.
  • Custom surface chart formatting is lost when a chart is copied and then pasted.
  • Data connection settings are not updated from an ODC file when the connection is set to “Always Use Connection File.”
  • Data is not rendered when you convert a linked chart in PowerPoint to another chart type and the Excel data sheet is closed.
  • Data labels on charts that were previously moved from their default positions change their location when you save to the XLS file format.
  • Date axis labels show the wrong date with the 1904 date system.
  • Deleting a column on a PivotTable with conditional formatting causes the workbook to become corrupted.
  • Embedding a 2007 workbook with a chart as the first sheet causes the chart to be resized if the window is small.
  • Excel 2007 becomes unresponsive when you switch from page layout view to another view if the workbook has a very complex chart in it.
  • Excel 2007 modifies the data source range of certain PivotTables created in earlier versions of Excel.
  • Excel 2007 saves formulas that are too long for Excel 2003 into an .xls file. An error, “File error: data may have been lost.” may occur when opening the file in Excel 2003.
  • Excel cannot refresh links to an external XLSB workbook if it contains records from a future Excel version (post-2007).
  • Excel crashes due to events raised to an add-in during recalculation.
  • Excel crashes on loading a workbook with corrupted names.
  • Excel crashes when a macro assigned to a picture or shape closes the workbook.
  • Excel does not ask if you want to save a file if your last step was to copy a chart into another application.
  • Excel does not load an Excel 2007 binary workbook (Biff12) with the value 1048576 in the cRw field of the BrtSupNameValueStart record or with the value 16384 in the cCol field of the BrtSupNameValueStart record.
  • Excel fails to load a file downloaded from an ASP or ASPX Web page.
  • Excel fails to load an XLSB file with a Web query that has a missing item.
  • Excel fails to open Office Open XML (xlsx) files that have elements or attributes that Excel does not implement.
  • Excel hangs after you create a secondary value axis and delete the first value axis, which was based on a logarithmic scale.
  • Excel hangs when you open a workbook attached to an Outlook note.
  • Excel hangs when you press F9 to evaluate certain formulas during Edit mode.
  • Excel incorrectly identifies which column is category and value when the data source has columns that are not next to each other.
  • Excel may crash when you interact with a right-to-left sheet that has hidden columns.
  • External references to cells in a closed file are not cleared after the source cells are cleared.
  • Fast scrolling using the mouse wheel can crash Excel.
  • For a combination chart that contains line and stacked areas, “Zero” is the only option available for the “Show empty cells as” setting in the “Hidden and Empty Cell Settings” dialog box.
  • For a PivotTable in an XLSB workbook, when a calculated item formula that is used by another calculated item formula is deleted, the file becomes corrupted.
  • For charts containing multiple series of chart types, the axis may not work correctly.
  • For charts that contain series of different chart types, the “Hidden and Empty Cells” settings do not work correctly.
  • For charts with a trendline that has specific data, the first argument of the trendline is sometimes calculated incorrectly.
  • For charts with an undefined graph chart type the name of the graph may display incorrectly.
  • For charts with polynomial trendlines, the first coefficient of the polynomial trendline equation is not being considered.
  • For charts, text within text boxes and shapes may be clipped when you open the file in previous versions of Excel.
  • For DataLabels and Legends, the object model property Format.TextFrame2 is not working properly.
  • Formatting lines on 3D charts is disabled if the line has automatic formatting.
  • Getting and setting ChartArea.Interior.PatternColorIndex by using the Excel constants xlColorIndexAutomatic and xlColorIndexNone does not produce the expected result.
  • Getting the value of the OLEObjects.Visible property in VBA fails in some cases, depending on sheet content.
  • Graphical objects can be the wrong size when you load an Excel worksheet that is set to show formulas.
  • Graphical objects may not shift correctly when you delete rows or cells above them.
  • Grouped shapes move by a few pixels when you save them in an .xls file and then re-open in Excel 2007.
  • Horizontal axis labels do not wrap correctly when the chart contains a data table and is using automatic rotation on the axis.
  • If a chart is active and an undo/delete operation occurs, the data is not updated until the next action is taken.
  • If a chart is active and something is deleted or undo is used, the chart data source is not updated until another action is performed.
  • If a chart with an automatic title is copied and pasted, the series on the pasted chart cannot be deleted.
  • If the PivotCache.MaintainConnection property is set to false, Excel takes a very long time to display the member property sub-menu when a user tries to access this sub-menu from the PivotTable’s context menu.
  • In an Excel worksheet containing many graphical objects, object model code which manipulates cells runs much more slowly than in previous versions of the application.
  • In an Excel worksheet containing many graphical objects, some actions are significantly slower than expected.
  • In certain circumstances, inserting columns causes graphical objects to redraw incorrectly.
  • In certain workbooks, formulas would not recalculate despite the workbook being in automatic calculation mode.
  • In Excel 2003, you change a name reference in the formula of a shape. When you reopen the workbook in Excel 2007, the changes are lost, and the shape formula stops calculating.
  • In Excel 2007, camera objects of shapes with text can become out of sync when the target shape is located on a different worksheet.
  • In Excel 2007, copying a cell selection that contains graphical objects and pasting as a picture can distort the rendering of the objects in the picture when the zoom level of the worksheet is not 100%.
  • In Excel 2007, enabling the AutoSize feature for shapes does not produce the same results as with previous versions the product.
  • In Excel 2007, inserting graphical objects into a sheet containing split panes can behave unexpectedly.
  • In Excel 2007, selecting a shape on a protected worksheet set to “Locked” but not “Lock Text” causes unexpected behavior.
  • In Excel 2007, the “Resize shape to fit text” option remains enabled after you manually resize a shape.
  • In Excel 2007, the bottom of the sheet area is sometimes truncated when printing.
  • In Excel 2007’s page layout view, ink strokes can unexpectedly flash very rapidly when selected.
  • In Excel, a text box’s horizontal alignment value is not persisted when that value is set to Centered and the file is saved to the Microsoft Office 97-2003 format.
  • In Excel, elbow or curved connectors can be printed as a straight line.
  • In Excel, if the theme is changed when a cell comment is selected, it is no longer possible to unselect the comment.
  • In Excel, sheet protection does not correctly lock the properties of graphical objects when the “Lock Text” option is set to false.
  • In Excel, text added to a shape in a chart spills outside the shape as opposed to clipping to edges of the shape.
  • In Excel, text added to a shape in a worksheet spills outside the shape as opposed to clipping to edges of the shape.
  • In Excel’s page layout view, the text cursor is located outside of a text box if the sheet is set to display in right-to-left mode.
  • In formulas that refer into sorted ranges in shared workbooks, the reference becomes a “#REF!” error.
  • In PowerPoint, a pie chart that contains a value of 0 is not displayed correctly in slide show mode.
  • In some cases, a workbook with query tables becomes corrupted during Save, and repairing it removes the query table definitions.
  • In some cases, saving a PivotTable with custom formatting results in a corrupted file.
  • In some languages, a chart would have a different currency symbol than the data in the workbook would have.
  • In some languages, a macro recording of an autofiltering by date operation does not play back.
  • Ink objects on top of far-away areas of a worksheet are lost when the workbook is saved and reopened.
  • It is possible to insert a ClipArt object into a protected worksheet.
  • Leader lines are lost after you save and reload a file that contains a pie chart with data labels.
  • Loading and saving DB3/DB4 files is prevented when the option to block text files is on.
  • Log charts sometimes incorrectly display an error message: “Negative or zero values cannot be plotted correctly on log charts.” This issue occurs even when there are no negative or zero values in the log chart.
  • Macro recording is not implemented for timescale axes on charts.
  • Macros recorded by using some Solver add-in functionality do not run and display run-time errors in certain languages.
  • Merging shared workbooks ends up with a corrupted file.
  • New charts are not created if the printer initialization failed.
  • On OLE charts, the plot area is smaller than that in Office 2003.
  • On right-to-left worksheets, inserting a picture does not work correctly when a cell near the right edge of the grid is selected.
  • On worksheets with many shapes, auto-filtering takes a very long time to complete.
  • Parts of shapes or other graphical objects with 3D effects in Excel might not print if the worksheet contains a repeating row or column.
  • Paste a chart as an OLE object or as a picture into an OLE client from a worksheet that has the magnification set to a setting other than 100%. The chart is incorrectly positioned in the OLE client.
  • Printing a chart to a printer that contains a different paper size than the selected paper size for the chart produces an error message “number must be between 10 and 400”.
  • Programmatically setting activecell.Borders.ColorIndex to xlNone fails.
  • Rich text sub-strings are not loaded in a reference to a closed workbook.
  • Rotated axis labels may disappear or may be truncated at certain rotation angles.
  • Saving an OLE DB-based PivotTable into Excel 5.0 file format and loading it triggers repair mode.
  • Scaled up pages with repeating columns cause some content not to be printed.
  • Selection of chart elements is disabled in the object model for protected sheets.
  • Series line draws incorrectly if there are blank cells in the data source.
  • Setting a Boolean value to some PivotTable properties in VBA code is locale dependent (the English constant TRUE is not recognized as a Boolean value).
  • Setting the Series.Name object model property on a chart does not add the series name to the series formula.
  • Setting the timescale type on the series axis of a chart causes a runtime error.
  • Several keyboard shortcuts are broken in some localized versions of Excel.
  • Shadow and glow effects do not animate correctly on charts in PowerPoint.
  • Shapes do not resize correctly when you perform an Undo operation after you insert or delete a row or column.
  • Shapes may not display correctly when the sheet direction is toggled between left-to-right and right-to-left.
  • Shapes that are far down in the worksheet and that are not at 100% scale are not printed.
  • Shapes that are set to “Do not move or size with cells” are resized after you cut and paste a column from one sheet to another.
  • Some ActiveX control properties are truncated or modified when the workbook they are in is saved as an .xlsx file.
  • Some category axis labels are not displayed on a chart when the date axis has a large range and sparse labels.
  • Some sheets are redrawn incorrectly when you copy them from a workbook with sheet tabs and the horizontal scroll bar turned off to a workbook with one or both of those bottom adornments turned on.
  • Some VBA code run from PowerPoint on an embedded Excel object will cause Excel to become unresponsive, depending on the last visible row prior to running the code.
  • Some workbooks with split panes are reported as corrupted by Excel 2007 SP1.
  • Some XLS workbooks with PivotTables are detected as corrupted during loading, and the PivotTable is discarded.
  • Stacked bar and column charts can have an incorrect blank space between series within the same category.
  • Text boxes become smaller every time that you save as an .xls file once the file has been opened and saved in Excel 2007.
  • Text in legacy WordArt shapes is flipped when the sheet direction is changed to right-to-left.
  • Text may be clipped in shapes that were created in Excel 2007 when you view the text in earlier versions of Excel.
  • Text padding on chart hierarchical axes is different from Office 2003.
  • Textboxes that have multiple lines of text, especially in Asian fonts, have different line spacing in Excel 2007 than in earlier versions of Excel. This may cause text clipping. To enable compatible handling of this situation, set the [HKEY_LOCAL_MACHINESOFTWAREPoliciesMicrosoftOffice12.0ExcelOptions] FixUpLegacyTextLineHeights DWORD:1 registry key.
  • The “Reset to Match Style” feature for a chart is not available in the object model.
  • The CHAR function returns an error for values above 256. Therefore, not all UTF8 characters can be displayed.
  • The chart FormulaLocal object model method does not parse correctly based on the localized language.
  • The chart object header margin and footer margin are switched when you save.
  • The Chart object model AutoFormat method produces unexpected results in some cases.
  • The conditional formatting “Last Month” condition fails if the current month is January.
  • The data points of a chart on the primary and secondary axes do not always align correctly when the secondary category axis is hidden.
  • The DATEDIF function returns the wrong result when the option (third) parameter is “yd.”
  • The day of the week is incorrect in date formats that use non-Gregorian calendars.
  • The Document Management status pane becomes disabled if a user starts typing in an Excel cell. Prior to SP2, it was necessary to switch between tabs on the Document Management pane before it would be re-enabled.
  • The Duplicate Name dialog box is not displayed when you open a workbook that contains names that are duplicates of built-in names.
  • The EOMONTH function returns the wrong date when the workbook is in 1904 date mode.
  • The Euro tool add-in does not support the currencies for Malta and Cyprus, two countries that are now part of the Euro zone.
  • The formatting that is applied to the first word or character in Excel 2003 charts is applied to entire text box (i.e., title, axis title) when you open the file in Excel 2007.
  • The Insert picture option is enabled in the user interface when a chart sheet is protected.
  • The month name is wrong when the date format uses the Hebrew lunar calendar and the date is in a leap year.
  • The Moving Average Trendlines are not being drawn correctly for charts when they are based on data that contains #N/A or blank values.
  • The new chart series is not added to the chart when you use Paste Special to add both the new categories and series.
  • The object model incorrectly returns a series as the parent of a Chart Group. The parent of a Chart Group should be a Chart.
  • The object model property Selection.Count does not return a correct value when multiple chart objects are selected.
  • The object model property Series.XValue returns the formatted value and not the numerical value for charts containing date values.
  • The OLEObjects.Visible method returns the wrong value for a hidden forms control after you paste text into the worksheet.
  • The order of member properties in a PivotTable’s Property Fields dialog box is incorrect. It does not follow the order set by the user.
  • The Pictures.Paste object model method does not produce the expected results on a chart.
  • The PRICEDISC function returns inconsistent results with some high parameter values.
  • The relative position of shapes is not maintained when you paste multiple shapes into a worksheet set to display in right-to-left mode.
  • The selection does not change to the series after you set the Series.AxisGroup object model property.
  • The Trendline.DataLabel.Top and Trendline.DataLabel.Left properties of a chart return the incorrect values if the chart has not been rendered.
  • The value of the Top property of the Line object is affected by Zoom level. This leads to incorrect placement of line shapes when this value is set programmatically to lines on a sheet that is zoomed to anything other than 100%.
  • The VBA method Selection.CopyPicture does not copy the bitmap picture format to the clipboard.
  • The width of the Up/Down bars in stock charts is not resized when the axis settings are changed.
  • The WORKDAY function returns the wrong result when the workbook is in 1904 date mode.
  • The wrong chart element is recorded when you change the properties on a series axis.
  • Theme information is not retained in PowerPoint when a chart saved in Office 2007 is edited using Office 2003.
  • This applies to charts that contain axes with dates in non-English locales. In the Format Axis dialog box, setting the Axis Options Minimum or Maximum value to Fixed causes the chart to be shown incorrectly.
  • Tooltips may display the wrong information about chart values.
  • Under certain conditions, turning on sheet tabs and selecting a different sheet causes the tabs to disappear again.
  • Undo does not work correctly if the previous action was changing the source data formatting to currency, causing the axis format to use currency.
  • Undo of a chart type change does not work correctly in Word.
  • Users cannot paste text into a text box in charts.
  • Using Regression in Analysis Tool Pack, the residual output table is different between Excel 2003 and Excel 2007.
  • Using the object model, it is possible to edit text in a shape located on a protected sheet.
  • VLOOKUP returns the wrong results when it looks up a number in Lotus compatibility mode.
  • When a chart axis has all negative values, the trendline will extend beyond the chart area.
  • When a data label is unlinked, it uses the format from the value field and not from the category field even if the data label is set to only display the category field.
  • When a data label is unlinked, it uses the format from the value field even if the data label was only set to display the category field.
  • When a PivotTable’s layout is mixed (some fields are compact and some use tabular layout), the GetPivotData function returns the wrong result for attribute subtotals with grouping.
  • When an AutoFilter is created on an entire row, data in rows hidden by the AutoFilter gets deleted when entire rows around the data are deleted.
  • When an Excel file containing a Surface Chart that was created in Excel 2007 is opened in the earlier versions of Excel, the file is opened in read-only mode.
  • When Excel opens a macro-enabled file from a Web site in Internet Explorer 7, the security dialog box opens under the Internet Explorer window and waits for a user response.
  • When graphical objects are added to a worksheet, the maximum allowed length of text in a cell comment is incorrectly restricted to 32 characters when you add text via the object model.
  • When inking on a chart sheet, the pen selects or modifies elements of the chart instead of drawing an ink stroke.
  • When sheet-level macros are moved together with a sheet into a different workbook, formulas in the original workbook referring to those macros are not adjusted.
  • When the series formula is set using the Series.Formula and Series.Formula R1C1 methods, the source dialog does not display the localized series formula in a non-English environment.
  • When you add text to a graphical object, typing performance can be extremely poor if a camera tool exists on the worksheet.
  • When you call an RealTimeData server from an XLL user-defined function that is called in an array formula, a “#VALUE!” error is returned.
  • When you convert a scatter series chart to a chart type that works for timescale (i.e., your category data is date driven), the category axis will not pick up the timescale.
  • When you copy from Excel and then use the Paste Special as Excel Worksheet option to paste into OpenOffice Calc, Excel may crash.
  • When you create a chart sheet in Excel 2007 and then open it in Excel 2003, the chart sheet becomes smaller.
  • When you open an .xls file, the Japanese Yen currency symbol is displayed as a backslash if the Office Primary Editing Language does not equal Japanese.
  • When you perform a cut/copy/paste operation on a range that encloses a chart, a shape, or a SmartArt object on a right-to-left sheet, the object is not copied or moved with the range.
  • When you press CTRL and use a drag-and-drop operation to copy a chart, the data source reference is incorrect in the newly created chart.
  • When you print Excel worksheets containing graphical objects, the underlying grid lines can print on top of the graphical objects.
  • When you print or publish to PDF format, too many page breaks may appear in the printed output. This occurs when the A4 paper size is selected but not supported on the active printer and when Excel uses the option to scale from A4 to Letter paper size.
  • When you print to a PCL printer, graphical objects may not print when the worksheet is set to right-to-left and page scaling is not 100%.
  • When you refresh a query table, the AfterCalculate event is raised before the AfterRefresh event.
  • When you save an .xlsx file that contains a chart, the sheetView element may be stored out incorrectly.
  • When you save East Asian and complex script text in charts in Excel 2007 in the .xls file format, the font changes to a Latin font.
  • When you save this workbook as an .xls file with a combination of buttons and shapes, the buttons may move and resize.
  • When you try to programmatically add a bullet character to a shape, the shape disappears.
  • When you type a double-byte character set character in the Visual Basic Editor, a full-width character is displayed.
  • When you ungroup in a large PivotTable that has conditional formatting applied, Excel crashes.
  • When you use the Chart.ChartWizard object model method to convert a chart to a scatter chart, the resulting chart is different form when you do the same operation in Excel 2003.
  • When you use the Paste Special as SYLK format option to paste from another workbook, Excel crashes when you save.
  • When you view books that were initially edited in a different primary editing language, the formatting of the chart labels may be incorrect.
  • When you work with a chart sheet, the Shapes.Count object model command can return an incorrect number of graphical objects.
  • With certain OLE DB providers, when the connection is based on a user name and password, Excel fails to connect and displays an error.
  • You can select and format shapes and text boxes on a protected chart sheet.
  • You cannot create a chart on a sheet that has a dot in the sheet name.
  • You cannot programmatically set the autosize property to true on a button placed on a chart sheet.
  • You cannot programmatically turn off chart series labels through the Chart.ChartWizard method.
  • You cannot select the first data point of a series on a line chart by using the keyboard.
  • You cannot select the first point on a line chart using a keyboard.
  • You cannot select various chart elements through the object model when a shape has been added to the chart.
  • You cannot send an e-mail using Simple MAPI mail applications when Extended MAPI is not installed.
  • You receive an error message and you cannot get to the Formulas tab using the Turkish locale when you try to load the Conditional Sum (SUMIF) Excel add-in, or you try to select the Formulas tab in order to use the add-in.
subs profile e1563205311409 - Excel 2007 Service Pack 2 - the official fix list
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address