PC Review


Reply
Thread Tools Rate Thread

bug - named ranges point to wrong column after being moved inside anMS Query Table

 
 
TrumpCoup
Guest
Posts: n/a
 
      30th Jun 2010
I am using MS Query to retrieve data from the database.
I have named several columns (the entrire column, not just X rows in a
column).
With Excel 2003 I can move these (or other columns that are inside the
MS Query range) and the ranges all correctly point to the new
locations.
However, when doing this in Excel 2007, if I move a column (J) using
Cut/Insert to column B, the named range for column N shifts (to O).
My work around is to insert a new column where I want to move the
column to. Cut/Paste on top of this new column, and the new column
"magically" moves to the old range. And the existing ranges all point
to their correct locations.

My question is - Has anyone else experienced this? 2007 cut/insert
inside a MS Query table does not act the way it did in 2003
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
named ranges in conditional formating inside a pivottable Peter Microsoft Excel Discussion 1 18th Feb 2010 04:03 PM
What am I doing wrong with Ranges named within Macro... Joe Mac Microsoft Excel Programming 7 14th Nov 2008 10:28 PM
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... christian_spaceman Microsoft Excel Programming 3 24th Dec 2007 01:15 PM
Multiple Named Ranges in the Same Column =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Worksheet Functions 2 9th May 2007 12:48 AM
Named ranges - column/row question =?Utf-8?B?Q2Fyb2xlIE8=?= Microsoft Excel Misc 5 11th May 2005 02:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:11 AM.