Filed under MS Excel
|| English || 中文 || view 9907 ||

2011년 6월 27일 자로 Microsoft Office 2010의 새로운 업데이트 버전인 Microsoft Office 2010 Service Pack 1(SP1)이 나왔다. 

엑셀 2010
이 중 Excel(엑셀)에서 고쳐진 내용은 아래와 같다. 이렇게 많은 문제를 안고 써온 것이다.

  • Data is formatted incorrectly when conditional formatting (조건부 서식) rules that are based on standard deviation (specifically below 2 or 3 standard deviation) are applied.
  • Pasting a lot of rows takes a very long time when the row height must be changed.
  • Excel may stop responding when array formulas that are dependent on or are included in a circular reference (순환 참조) are calculated.
  • Excel may crash or save an unreadable file if a sheet that contains defined names that refer to a worksheet are copied or moved to a different workbook.
  • When an Excel chart in a PowerPoint presentation is inserted into a new presentation through the "Reuse Slides" feature, the chart does not adopt the theme of the target presentation even if "Keep Source Formatting" option is not selected.
  • When a line chart is based on a named range for which at least one element evaluates to #N/A, the #N/A value appears as 0 on the chart and does not interpolate the #N/A data points as expected.
  • Excel crashes when a table that has styles applied as block-level formatting is copied into another workbook.
  • If an Excel 2003 chart or graph object in PowerPoint 2003 uses the accent colors from the color palette, these colors are converted to black when the file is opened in PowerPoint 2010.
  • Excel crashes when you are using a PivotTable and PivotChart after you perform drill operations, undo multiple operations at once, modify the PivotChart, and then save the file.
  • Hidden columns become visible when data is copied between worksheets that have different default column widths.
  • Data labels on a chart can be incorrectly hidden when the label has a custom position, and the file is saved as .xls file type.
  • When accessed programmatically, some methods return incorrect results when you have multiple conditional formats on different ranges that intersect.
  • Cells that have “center across selection” formatting options applied are not correctly redrawn after a calculation. This can create "redraw artifacts" or the appearance of a recalculation problem.
  • Data is formatted incorrectly when you apply conditional formatting rules to a range that includes a non-volatile function that is followed by a volatile function (such as RAND()),
  • Excel crashes when you select the value field header cell of a PivotTable that has all data filtered out.
  • The order of the legend entries that are displayed in the legend of a stack chart that was created in Excel 2003 is reversed when the chart is opened in Excel 2010 if the legend was modified to have a custom position.
  • Data is not displayed correctly on a chart when you open a workbook that was created in a previous versions of Excel and that has the BIFF3, BIFF4, or BIFF5 file formats, if the chart is based on external data (such as a from a .dat file).
  • When you open a hyperlink that points to an Excel file (.XLSX format file), the file opens in the "restored" state and the window is not maximized.
  • After copying a sheet with an object that has a macro associated with it to another workbook, the macro does not work correctly because it is not correctly pointing at the source workbook.
  • When you import a text file, certain decimal values are not recognized as numeric.
  • A Pivot Table can become corrupted if member properties in the OLAP cube on which the Pivot Table is based are added, modified, or deleted.
  • When multithreaded calculation is disabled, calculation is slow when the total number of formulas in all loaded workbooks is large, and a small subset of those formulas are repeatedly calculated.
  • XMLSS type files do not open if the program is in Protected View mode.
  • When cell editing is disabled and you double-click a cell that contains a reference to a cell in another workbook, the source workbook opens, but the specific cell is not activated,
  • Documents that are saved in the Office 2003 file format that contain pie charts that had data labels outside the pie segments may display the labels inside the pie segments when the document is opened if the labels were edited before the file was saved.
  • A cell that is part of a conditional format range is temporarily not updated to reflect the conditional formatting result when the contents of the cell is deleted.
  • Excel crashes when you are using Remote Desktop and you try to perform a paste or print action, such as Paste As Picture Link.
  • A stacked area chart always fills from the plane that intersects with the zero value on the vertical axis instead of from the X axis crossing point.
  • Excel crashes when you open a file that contains a macro on an embedded object, and the file name contains a square bracket character ("[" or "]").
  • If custom formatting is applied to data points in a chart or if the "Vary colors by point" setting is enabled for a chart, formatting may be lost when you hide the corresponding series data.
  • A chart that was based on external data from a .DAT file will be missing from an .xlxs file if that file was an Excel 2003 file (.xls) that was saved in the Excel 2007 file format (.xlxs), moved to another directory, and then opened.
  • If you open a workbook containing a slicer in Excel 2007 and then save it to the XLSB format and then XLSX format, the next time file is opened in Excel 2010 it is reported as corrupted.
  • Excel crashes when you position the pointer over an area chart that has a date axis and a lot of blank cells in the chart data range.
  • In PowerPoint, the size of the Excel OLE chart object changes after you right-click and then open the chart object by using the Open command on the Chart Object menu.
  • A file that has a corrupted chart part is repaired silently. The user is not notified of the problem and prompted to approve the repair.
  • When you have an OLAP PivotTable that contains a hierarchy that has a hidden level and you are trying to create a named set that is based on the other PivotTable axis, the Tuple Definition dialog box displays the wrong fields. Excel crashes when you try to create the named set after you load a workbook that has this kind of PivotTable.
  • The SUMIFS, AVERAGEIFS, and COUNTIFS functions return incorrect results when the function contains two or more criteria ranges that come from at least two different sheets.
  • When you open an Excel file from a network share, the file is not correctly updated by the "Update File" feature from the Quick Access toolbar after another user has edited the file.
  • Certain array-entered formulas that reference ranges by using  formulas that reference operations or worksheet functions  that have not been fully calculated. The allocated strings (such as IF, CONCATENATE, or the "&" operator) may not calculate after certain operations, such as changing support cells, are performed.
  • If a named set that is based on measures hierarchy and for which at least one of the measures does not have data in a default context is placed on a PivotTable axis, the measure that lacks data is not displayed. If none of the measures have data, Excel might crash.
  • Excel stops responding or displays unpredictable behavior, such as incomplete calculations, when a workbook that has array formulas that contain VLOOKUP, LOOKUP, or HLOOKUP functions is calculated.
  • Blank dates in "2-D" and "3-D" area and line charts that have a date axis are not correctly ignored and are instead plotted as zero values.
  • You cannot install the Arabic - Saudi Arabia, Hebrew, Hindi, or Thai version of the Analysis Tool Pack add-in for Excel.
  • Surface charts (both wireframe and solid) are not drawn properly from certain data sets.
  • The camera tool and the "paste as picture" link are not resized when the cell range changes size in the linked worksheet.
  • When there are merged cells in Excel, the wrong cell range from a different worksheet may be shown.
  • A crash occurs when you open a workbook in Protected View but then cancel while the file is being opened.
  • When opening a file with the same name from multiple locations, Excel goes into a state in which the program cannot be closed.
  • Users cannot load certain previously saved Excel OLE objects in Excel 2010.
  • You open a workbook that has surface charts in Protected View. When you immediately try to edit the workbook, the program crashes.
  • A crash occurs when you open an Excel file that has surface charts in Protected View.
  • SP1 introduces a new checkbox, "Excel Toolbars Files" in the File Block Settings tab of the Trust Center, to allow a user/corporation to prevent users from opening Excel Toolbars (.xlb) files in Excel because of security concerns. Checking it sets a new registry key, XlbFiles, which blocks Excel Toolbars (.xlb) files from being opened.
"MS Excel" 분류의 다른 글
[Excel] 데이터 입력 일시 자동으로 기록하기 (0)2018/12/08  
[Excel] 숫자를 한글, 한자로 바꾸기 (2)2007/07/03  
[MS Excel] 여러 열에 골고루 흩어져 있는 값들을 한 열로 정리하고 어디 어디에 있는지 정리하기 (1)2008/02/20  
[Excel] 그림, 도형 등의 개체를 눈금선(셀 구분선)에 자석처럼 달라붙게 하기 (0)2007/08/03  
[Excel] 고급 필터에서 텍스트 값과 관련된 조건 만드는 방법 (0)2009/01/20  
  ◐ 관련 글 ◑   ◐ 100일간 인기 글 ◑
Creative Commons License 이 저작물은 크리에이티브 커먼즈 코리아 저작자 표시-비영리-변경 금지 2.0 대한민국 라이선스에 따라 이용하실 수 있습니다.

RSS 2.0 feed
ATOM 1.0 feed
Tag , , ,
You can track responses via RSS / ATOM feed
RSS 2.0 feed
ATOM 1.0 feed