https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172990&feed=atom&action=history
Microsoft KB Archive/172990 - Revision history
2024-03-28T17:08:59Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172990&diff=344116&oldid=prev
X010: Text replacement - """ to """
2020-07-21T10:06:36Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 10:06, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l47">Line 47:</td>
<td colspan="2" class="diff-lineno">Line 47:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* The row fields or column fields contain extra <del style="font-weight: bold; text-decoration: none;">&quot;</del>(blank)<del style="font-weight: bold; text-decoration: none;">&quot; </del>items.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* The row fields or column fields contain extra <ins style="font-weight: bold; text-decoration: none;">"</ins>(blank)<ins style="font-weight: bold; text-decoration: none;">" </ins>items.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* Most of the data in the PivotTable is aligned with the <del style="font-weight: bold; text-decoration: none;">&quot;</del>(blank)<del style="font-weight: bold; text-decoration: none;">&quot; </del>row or column fields instead of with the correct row or column fields.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* Most of the data in the PivotTable is aligned with the <ins style="font-weight: bold; text-decoration: none;">"</ins>(blank)<ins style="font-weight: bold; text-decoration: none;">" </ins>row or column fields instead of with the correct row or column fields.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l65">Line 65:</td>
<td colspan="2" class="diff-lineno">Line 65:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To work around this problem, unmerge any merged cells in the list of data used to create the PivotTable, fill the unmerged cells with field data, and update the PivotTable.<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To work around this problem, unmerge any merged cells in the list of data used to create the PivotTable, fill the unmerged cells with field data, and update the PivotTable.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The <del style="font-weight: bold; text-decoration: none;">&quot;</del>More Information<del style="font-weight: bold; text-decoration: none;">&quot; </del>section in this article contains an example of the problem.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The <ins style="font-weight: bold; text-decoration: none;">"</ins>More Information<ins style="font-weight: bold; text-decoration: none;">" </ins>section in this article contains an example of the problem.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Line 79:</td>
<td colspan="2" class="diff-lineno">Line 79:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The problem described in the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Symptoms<del style="font-weight: bold; text-decoration: none;">&quot; </del>section occurs because of the way that PivotTables in Microsoft Excel 97 retrieve data from cells in a worksheet. When you create a PivotTable, the PivotTable ignores any merged cells in the list of data and retrieves information stored in the individual cells. Because the cells are blank, they appear in the PivotTable as blank fields.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The problem described in the <ins style="font-weight: bold; text-decoration: none;">"</ins>Symptoms<ins style="font-weight: bold; text-decoration: none;">" </ins>section occurs because of the way that PivotTables in Microsoft Excel 97 retrieve data from cells in a worksheet. When you create a PivotTable, the PivotTable ignores any merged cells in the list of data and retrieves information stored in the individual cells. Because the cells are blank, they appear in the PivotTable as blank fields.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Example ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Example ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l123">Line 123:</td>
<td colspan="2" class="diff-lineno">Line 123:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> Grand Total 9 12 15 18 54</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> Grand Total 9 12 15 18 54</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </pre></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Note that all of the items in the PivotTable are grouped in the <del style="font-weight: bold; text-decoration: none;">&quot;</del>(blank)<del style="font-weight: bold; text-decoration: none;">&quot; </del>Widget Type except items in rows two, six, and ten in the worksheet. These items are next to the original data in the merged cells so that they are aligned with the correct Widget Types.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Note that all of the items in the PivotTable are grouped in the <ins style="font-weight: bold; text-decoration: none;">"</ins>(blank)<ins style="font-weight: bold; text-decoration: none;">" </ins>Widget Type except items in rows two, six, and ten in the worksheet. These items are next to the original data in the merged cells so that they are aligned with the correct Widget Types.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The items grouped into the <del style="font-weight: bold; text-decoration: none;">&quot;</del>(blank)<del style="font-weight: bold; text-decoration: none;">&quot; </del>Widget Type are in the same rows as the blank cells in step 1.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The items grouped into the <ins style="font-weight: bold; text-decoration: none;">"</ins>(blank)<ins style="font-weight: bold; text-decoration: none;">" </ins>Widget Type are in the same rows as the blank cells in step 1.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Correcting the Example:<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Correcting the Example:<br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l134">Line 134:</td>
<td colspan="2" class="diff-lineno">Line 134:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># In the worksheet, click cell A2. On the Format menu, click Cells. Click the Alignment tab. Click to clear the Merge Cells check box, and then click OK.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># In the worksheet, click cell A2. On the Format menu, click Cells. Click the Alignment tab. Click to clear the Merge Cells check box, and then click OK.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Repeat step 1 for cells A6 and A10.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Repeat step 1 for cells A6 and A10.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># Select cell A2 and fill the value <del style="font-weight: bold; text-decoration: none;">&quot;</del>Alpha<del style="font-weight: bold; text-decoration: none;">&quot; </del>down column A to cell A5. Then, fill the value <del style="font-weight: bold; text-decoration: none;">&quot;</del>Bravo<del style="font-weight: bold; text-decoration: none;">&quot; </del>in cell A6 down column A to cell A9 and fill the value <del style="font-weight: bold; text-decoration: none;">&quot;</del>Charlie<del style="font-weight: bold; text-decoration: none;">&quot; </del>in cell A10 down column A to cell A13.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># Select cell A2 and fill the value <ins style="font-weight: bold; text-decoration: none;">"</ins>Alpha<ins style="font-weight: bold; text-decoration: none;">" </ins>down column A to cell A5. Then, fill the value <ins style="font-weight: bold; text-decoration: none;">"</ins>Bravo<ins style="font-weight: bold; text-decoration: none;">" </ins>in cell A6 down column A to cell A9 and fill the value <ins style="font-weight: bold; text-decoration: none;">"</ins>Charlie<ins style="font-weight: bold; text-decoration: none;">" </ins>in cell A10 down column A to cell A13.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Click any cell in the PivotTable.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Click any cell in the PivotTable.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># On the Data menu, click Refresh Data.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># On the Data menu, click Refresh Data.</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172990&diff=91960&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:36:58Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB172990"></span>XL97: PivotTable Appears Incorrect If Data Contains Merged Cell =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 172990<br />
<br />
Article Last Modified on 10/22/2000<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Excel 97 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q172990<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
When you create a PivotTable in a worksheet in Microsoft Excel 97, the following problems may occur:<br /><br />
<br /><br />
<br />
* The row fields or column fields contain extra &quot;(blank)&quot; items.<br />
* Most of the data in the PivotTable is aligned with the &quot;(blank)&quot; row or column fields instead of with the correct row or column fields.<br />
<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
This problem may occur if the list of data used to create the PivotTable contains merged cells.<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
To work around this problem, unmerge any merged cells in the list of data used to create the PivotTable, fill the unmerged cells with field data, and update the PivotTable.<br /><br />
<br /><br />
The &quot;More Information&quot; section in this article contains an example of the problem.<br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
The problem described in the &quot;Symptoms&quot; section occurs because of the way that PivotTables in Microsoft Excel 97 retrieve data from cells in a worksheet. When you create a PivotTable, the PivotTable ignores any merged cells in the list of data and retrieves information stored in the individual cells. Because the cells are blank, they appear in the PivotTable as blank fields.<br />
=== Example ===<br />
<br />
The following steps demonstrate the problem in Microsoft Excel 97:<br /><br />
<br /><br />
<br />
<ol><br />
<li><p>In Microsoft Excel 97, create a new workbook. In Sheet1, enter the following data:</p><br />
<pre class="fixed_text"> A1: Widget Type B1: Quarter C1: Sales<br />
A2: Alpha B2: Q1 C2: 1<br />
B3: Q2 C3: 2<br />
B4: Q3 C4: 3<br />
B5: Q4 C5: 4<br />
A6: Bravo B6: Q1 C6: 5<br />
B7: Q2 C7: 6<br />
B8: Q3 C8: 7<br />
B9: Q4 C9: 8<br />
A10: Charlie B10: Q1 C10: 3<br />
B11: Q2 C11: 4<br />
B12: Q3 C12: 5<br />
B13: Q4 C13: 6<br />
</pre><br />
<p>Note that cells A3:A5, A7:A9, and A11:A13 are blank.</p></li><br />
<li>Select cells A2:A5. On the Formatting toolbar, click Merge And Center. Repeat this step with the A6:A9 and A10:A13 cell ranges.</li><br />
<li>Select cell B5. On the Data menu, click PivotTable Report.</li><br />
<li>In the PivotTable Wizard, do the following:<br /><br />
<br /><br />
<br />
<ol style="list-style-type: lower-alpha;"><br />
<li>In step 1 of the wizard, click Next.</li><br />
<li>In step 2 of the wizard, click Next.</li><br />
<li>In step 3 of the wizard, drag the Widget Type field to the ROW area in the diagram. Drag the Quarter field to the COLUMN area in the diagram. Drag the Sales field to the DATA area in the diagram. Then, click Next.</li><br />
<li>In step 4 of the wizard, click Existing Worksheet. Select cell A15 in the worksheet and click Finish.</li></ol><br />
</li></ol><br />
<br />
The following PivotTable appears in the worksheet:<br />
<pre class="fixed_text"> Sum of Sales Quarter<br />
Widget Type Q1 Q2 Q3 Q4 Grand Total<br />
Alpha 1 1<br />
Bravo 5 5<br />
Charlie 3 3<br />
(blank) 12 15 18 45<br />
Grand Total 9 12 15 18 54<br />
</pre><br />
Note that all of the items in the PivotTable are grouped in the &quot;(blank)&quot; Widget Type except items in rows two, six, and ten in the worksheet. These items are next to the original data in the merged cells so that they are aligned with the correct Widget Types.<br /><br />
<br /><br />
The items grouped into the &quot;(blank)&quot; Widget Type are in the same rows as the blank cells in step 1.<br /><br />
<br /><br />
Correcting the Example:<br /><br />
<br /><br />
To correct the problem in the example, do the following:<br /><br />
<br /><br />
<br />
# In the worksheet, click cell A2. On the Format menu, click Cells. Click the Alignment tab. Click to clear the Merge Cells check box, and then click OK.<br />
# Repeat step 1 for cells A6 and A10.<br />
# Select cell A2 and fill the value &quot;Alpha&quot; down column A to cell A5. Then, fill the value &quot;Bravo&quot; in cell A6 down column A to cell A9 and fill the value &quot;Charlie&quot; in cell A10 down column A to cell A13.<br />
# Click any cell in the PivotTable.<br />
# On the Data menu, click Refresh Data.<br />
<br />
The following PivotTable appears on the worksheet:<br />
<pre class="fixed_text"> Sum of Sales Quarter<br />
Widget Type Q1 Q2 Q3 Q4 Grand Total<br />
Alpha 1 2 3 4 10<br />
Bravo 5 6 7 8 26<br />
Charlie 3 4 5 6 18<br />
Grand Total 9 12 15 18 54<br />
</pre><br />
This PivotTable contains the correct information.<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: XL97 pivot table wrong order<br />
<br />
Keywords: kbprb KB172990<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd