Microsoft KB Archive/270097

= XL2001: Query Range Is Not Moved with the Data When Dragged to a List =

Article ID: 270097

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q270097



SYMPTOMS
When you drag a named region that contains a query into a list object, the data is moved, but the query range remains in the original location. Any data updates occur in the original location and not in the list object.



WORKAROUND
To work around this behavior, follow these steps:
 * 1) Select the entire query range.
 * 2) On the Insert menu, click List, and then click Finish.

The query range is now included inside a list object, and when you move the list object, the query range and its links are moved with it. Any updates refresh the data in the list object.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.



MORE INFORMATION
For more information about how to use queries, follow these steps:
 * 1) On the Help menu, click Contents and Index, click Index, and then click Q.
 * 2) Scroll down until you locate query, and then click the arrow to the left to view a list of topics under the general topic.
 * 3) Click About using Query to retrieve external data.

If you cannot find the information that you want, ask the Office Assistant.

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbpending KB270097

-

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

© Microsoft Corporation. All rights reserved.