![]() More Information Steps to reproduce the problemĬreate a new workbook in Office Excel 2007. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Unmerge the cell before you paste the formulas of the copied data. ![]() To work around this problem, use one of the following methods: This problem occurs because only the data that appears in the upper-left cell of the copied cells is visible in the merged cell. Additionally, the results of certain aggregation functions, such as the Sum aggregation, as displayed in the status bar do not match the expected results based on the visible data. However, because you only see one of the component cells of the merged cell, the calculation result might differ from the result that you expect. Excel then calculates the result by using all the formulas in the underlying cells of the merged cell. ![]() In this scenario, the paste may apply the formula to each underlying cell of the merged cell, if the source range is not also a merged cell of the same size. ![]() Assume that you paste a range of cells as formulas into a merged cell in Microsoft Excel 2000, in Excel 2002, in Excel 2003, in Excel 2007, or in Excel 2010.
0 Comments
Leave a Reply. |