Microsoft KB Archive/282133

= XL2002: Columns Are Removed and Other Columns Are Moved to the Left When You Refresh Query Table =

Article ID: 282133

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q282133



SYMPTOMS
When you refresh a table of external data in a Microsoft Excel workbook, some of the columns may be removed, and other columns may be added and/or moved to the left. References to the missing columns change to #REF.



CAUSE
This behavior occurs when all of the following conditions are true:
 * You refresh data from an external source.

-and-
 * The column names have changed in the external source.

-and-
 * The query option to preserve the original column layout is selected.



RESOLUTION
To resolve this issue, follow these steps:
 * 1) On the Edit menu, click Undo Refresh Data.
 * 2) Click anywhere in the imported data, and then click Data Range Properties on the External Data toolbar.
 * 3) Click to clear the Preserve column sort/filter/layout check box, and then click OK.
 * 4) On the External Data toolbar, click Refresh Data.

Additional query words: XL2002 prb #REF

Keywords: kbpending kbprb KB282133

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.