I am trying to filter some data in Excel 2007 using autofilters and copy the
result set data to clipboard using ctrl + C and paste it on a separate work
book using ctrl + V. However, it is copying all the filtered rows data also
instead of only the visible rows.

This is not the desired behavior. Is there a way to achieve this as is done
in Excel 2003.

SeethaRaman

SeethaRaman

Sorry, can't replicate...works fine here, both with standard filters and
table ones. In fact they work the same

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"SeethaRaman" <(E-Mail Removed)> wrote in message
news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>I am trying to filter some data in Excel 2007 using autofilters and copy
>the
> result set data to clipboard using ctrl + C and paste it on a separate
> work
> book using ctrl + V. However, it is copying all the filtered rows data
> also
> instead of only the visible rows.
>
> This is not the desired behavior. Is there a way to achieve this as is
> done
> in Excel 2003.
>
> SeethaRaman

I am able to consistantly repro this. I am not sure what I am missing here. I
have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
columns. All the 8 columns have autofilter set. I apply different filters on
couple of columns and select the first column values using ctrl + C and paste
it another spread sheet. I am getting all the rows instead of the filtered
values only.

Please let me know how I can repro this to you.

SeethaRaman

"Nick Hodge" wrote:

> SeethaRaman
>
> Sorry, can't replicate...works fine here, both with standard filters and
> table ones. In fact they work the same
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "SeethaRaman" <(E-Mail Removed)> wrote in message
> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
> >I am trying to filter some data in Excel 2007 using autofilters and copy
> >the
> > result set data to clipboard using ctrl + C and paste it on a separate
> > work
> > book using ctrl + V. However, it is copying all the filtered rows data
> > also
> > instead of only the visible rows.
> >
> > This is not the desired behavior. Is there a way to achieve this as is
> > done
> > in Excel 2003.
> >
> > SeethaRaman
>
>
>

SeethaRaman

Couple of things I've not tried is multiple filters and copying one column.
I take a look and get back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"SeethaRaman" <(E-Mail Removed)> wrote in message
news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
>I am able to consistantly repro this. I am not sure what I am missing here.
>I
> have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
> columns. All the 8 columns have autofilter set. I apply different filters
> on
> couple of columns and select the first column values using ctrl + C and
> paste
> it another spread sheet. I am getting all the rows instead of the filtered
> values only.
>
> Please let me know how I can repro this to you.
>
> SeethaRaman
>
> "Nick Hodge" wrote:
>
>> SeethaRaman
>>
>> Sorry, can't replicate...works fine here, both with standard filters and
>> table ones. In fact they work the same
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> www.nickhodge.co.uk
>> (E-Mail Removed)HIS
>>
>>
>> "SeethaRaman" <(E-Mail Removed)> wrote in message
>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>> >I am trying to filter some data in Excel 2007 using autofilters and copy
>> >the
>> > result set data to clipboard using ctrl + C and paste it on a separate
>> > work
>> > book using ctrl + V. However, it is copying all the filtered rows data
>> > also
>> > instead of only the visible rows.
>> >
>> > This is not the desired behavior. Is there a way to achieve this as is
>> > done
>> > in Excel 2003.
>> >
>> > SeethaRaman
>>
>>
>>

SeethaRaman

I have now tried this with more rows and multiple filters (5 rows filtered).
I have tried selecting entire columns, just the used data in a column, the
entire filtered data set (and the row below), the entire sheet and in each
occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
just the filtered list

Is this a new file or a previous version one? If it's updated could you try
this with a new 2007 workbook?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Nick Hodge" <(E-Mail Removed)> wrote in message
news:Oz17%(E-Mail Removed)...
> SeethaRaman
>
> Couple of things I've not tried is multiple filters and copying one
> column. I take a look and get back
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "SeethaRaman" <(E-Mail Removed)> wrote in message
> news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
>>I am able to consistantly repro this. I am not sure what I am missing
>>here. I
>> have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
>> columns. All the 8 columns have autofilter set. I apply different filters
>> on
>> couple of columns and select the first column values using ctrl + C and
>> paste
>> it another spread sheet. I am getting all the rows instead of the
>> filtered
>> values only.
>>
>> Please let me know how I can repro this to you.
>>
>> SeethaRaman
>>
>> "Nick Hodge" wrote:
>>
>>> SeethaRaman
>>>
>>> Sorry, can't replicate...works fine here, both with standard filters and
>>> table ones. In fact they work the same
>>>
>>> --
>>> HTH
>>> Nick Hodge
>>> Microsoft MVP - Excel
>>> Southampton, England
>>> www.nickhodge.co.uk
>>> (E-Mail Removed)HIS
>>>
>>>
>>> "SeethaRaman" <(E-Mail Removed)> wrote in message
>>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>>> >I am trying to filter some data in Excel 2007 using autofilters and
>>> >copy
>>> >the
>>> > result set data to clipboard using ctrl + C and paste it on a separate
>>> > work
>>> > book using ctrl + V. However, it is copying all the filtered rows data
>>> > also
>>> > instead of only the visible rows.
>>> >
>>> > This is not the desired behavior. Is there a way to achieve this as is
>>> > done
>>> > in Excel 2003.
>>> >
>>> > SeethaRaman
>>>
>>>
>>>
>
>

Sorry for getting back to you this late.
The earlier one was an updated Excel sheet from Excel 2003 and opened in
Compatibility mode with Excel 2007.

I have created a new work book using Excel 2007, copy pasted all the data
from old XLS file, saved it as XLSX file (new extension for Excel 2007). Now
I apply filter (not even multiple, only one filter on a particular column)
and selected first few row values from first column and pasted to a new
excel. Now I again get all the rows which are filtered.

This is a bug. No doubt.

SeethaRaman

"Nick Hodge" wrote:

> SeethaRaman
>
> I have now tried this with more rows and multiple filters (5 rows filtered).
> I have tried selecting entire columns, just the used data in a column, the
> entire filtered data set (and the row below), the entire sheet and in each
> occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
> just the filtered list
>
> Is this a new file or a previous version one? If it's updated could you try
> this with a new 2007 workbook?
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "Nick Hodge" <(E-Mail Removed)> wrote in message
> news:Oz17%(E-Mail Removed)...
> > SeethaRaman
> >
> > Couple of things I've not tried is multiple filters and copying one
> > column. I take a look and get back
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > www.nickhodge.co.uk
> > (E-Mail Removed)HIS
> >
> >
> > "SeethaRaman" <(E-Mail Removed)> wrote in message
> > news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
> >>I am able to consistantly repro this. I am not sure what I am missing
> >>here. I
> >> have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
> >> columns. All the 8 columns have autofilter set. I apply different filters
> >> on
> >> couple of columns and select the first column values using ctrl + C and
> >> paste
> >> it another spread sheet. I am getting all the rows instead of the
> >> filtered
> >> values only.
> >>
> >> Please let me know how I can repro this to you.
> >>
> >> SeethaRaman
> >>
> >> "Nick Hodge" wrote:
> >>
> >>> SeethaRaman
> >>>
> >>> Sorry, can't replicate...works fine here, both with standard filters and
> >>> table ones. In fact they work the same
> >>>
> >>> --
> >>> HTH
> >>> Nick Hodge
> >>> Microsoft MVP - Excel
> >>> Southampton, England
> >>> www.nickhodge.co.uk
> >>> (E-Mail Removed)HIS
> >>>
> >>>
> >>> "SeethaRaman" <(E-Mail Removed)> wrote in message
> >>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
> >>> >I am trying to filter some data in Excel 2007 using autofilters and
> >>> >copy
> >>> >the
> >>> > result set data to clipboard using ctrl + C and paste it on a separate
> >>> > work
> >>> > book using ctrl + V. However, it is copying all the filtered rows data
> >>> > also
> >>> > instead of only the visible rows.
> >>> >
> >>> > This is not the desired behavior. Is there a way to achieve this as is
> >>> > done
> >>> > in Excel 2003.
> >>> >
> >>> > SeethaRaman
> >>>
> >>>
> >>>
> >
> >
>
>
>

SeethaRaman

I've posted this on a beta newsgroup I have and see if I get any better
answers for you as I can't replicate how ever hard I try

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"SeethaRaman" <(E-Mail Removed)> wrote in message
news:17A1697C-0366-42EA-8314-(E-Mail Removed)...
> Sorry for getting back to you this late.
> The earlier one was an updated Excel sheet from Excel 2003 and opened in
> Compatibility mode with Excel 2007.
>
> I have created a new work book using Excel 2007, copy pasted all the data
> from old XLS file, saved it as XLSX file (new extension for Excel 2007).
> Now
> I apply filter (not even multiple, only one filter on a particular column)
> and selected first few row values from first column and pasted to a new
> excel. Now I again get all the rows which are filtered.
>
> This is a bug. No doubt.
>
> SeethaRaman
>
> "Nick Hodge" wrote:
>
>> SeethaRaman
>>
>> I have now tried this with more rows and multiple filters (5 rows
>> filtered).
>> I have tried selecting entire columns, just the used data in a column,
>> the
>> entire filtered data set (and the row below), the entire sheet and in
>> each
>> occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
>> just the filtered list
>>
>> Is this a new file or a previous version one? If it's updated could you
>> try
>> this with a new 2007 workbook?
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> www.nickhodge.co.uk
>> (E-Mail Removed)HIS
>>
>>
>> "Nick Hodge" <(E-Mail Removed)> wrote in message
>> news:Oz17%(E-Mail Removed)...
>> > SeethaRaman
>> >
>> > Couple of things I've not tried is multiple filters and copying one
>> > column. I take a look and get back
>> >
>> > --
>> > HTH
>> > Nick Hodge
>> > Microsoft MVP - Excel
>> > Southampton, England
>> > www.nickhodge.co.uk
>> > (E-Mail Removed)HIS
>> >
>> >
>> > "SeethaRaman" <(E-Mail Removed)> wrote in message
>> > news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
>> >>I am able to consistantly repro this. I am not sure what I am missing
>> >>here. I
>> >> have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
>> >> columns. All the 8 columns have autofilter set. I apply different
>> >> filters
>> >> on
>> >> couple of columns and select the first column values using ctrl + C
>> >> and
>> >> paste
>> >> it another spread sheet. I am getting all the rows instead of the
>> >> filtered
>> >> values only.
>> >>
>> >> Please let me know how I can repro this to you.
>> >>
>> >> SeethaRaman
>> >>
>> >> "Nick Hodge" wrote:
>> >>
>> >>> SeethaRaman
>> >>>
>> >>> Sorry, can't replicate...works fine here, both with standard filters
>> >>> and
>> >>> table ones. In fact they work the same
>> >>>
>> >>> --
>> >>> HTH
>> >>> Nick Hodge
>> >>> Microsoft MVP - Excel
>> >>> Southampton, England
>> >>> www.nickhodge.co.uk
>> >>> (E-Mail Removed)HIS
>> >>>
>> >>>
>> >>> "SeethaRaman" <(E-Mail Removed)> wrote in
>> >>> message
>> >>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>> >>> >I am trying to filter some data in Excel 2007 using autofilters and
>> >>> >copy
>> >>> >the
>> >>> > result set data to clipboard using ctrl + C and paste it on a
>> >>> > separate
>> >>> > work
>> >>> > book using ctrl + V. However, it is copying all the filtered rows
>> >>> > data
>> >>> > also
>> >>> > instead of only the visible rows.
>> >>> >
>> >>> > This is not the desired behavior. Is there a way to achieve this as
>> >>> > is
>> >>> > done
>> >>> > in Excel 2003.
>> >>> >
>> >>> > SeethaRaman
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>

SeethaRaman

I've got no one at MS to repro this either. Can you list me detailed steps
and we'll all try and repro. (remember things like version detail, new or
old workbooks, etc.)

If we still fail, I'll possibly get the workbook from you or put you in
touch directly.

Interestingly I came across another while testing. If you filter several
columns when set up as a 'table' and just copy the rows the formatting style
(bight blue, dark blue, etc) gets copied over. If you copy and paste the
entire column the formatting gets lost

Later....

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Nick Hodge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> SeethaRaman
>
> I've posted this on a beta newsgroup I have and see if I get any better
> answers for you as I can't replicate how ever hard I try
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "SeethaRaman" <(E-Mail Removed)> wrote in message
> news:17A1697C-0366-42EA-8314-(E-Mail Removed)...
>> Sorry for getting back to you this late.
>> The earlier one was an updated Excel sheet from Excel 2003 and opened in
>> Compatibility mode with Excel 2007.
>>
>> I have created a new work book using Excel 2007, copy pasted all the data
>> from old XLS file, saved it as XLSX file (new extension for Excel 2007).
>> Now
>> I apply filter (not even multiple, only one filter on a particular
>> column)
>> and selected first few row values from first column and pasted to a new
>> excel. Now I again get all the rows which are filtered.
>>
>> This is a bug. No doubt.
>>
>> SeethaRaman
>>
>> "Nick Hodge" wrote:
>>
>>> SeethaRaman
>>>
>>> I have now tried this with more rows and multiple filters (5 rows
>>> filtered).
>>> I have tried selecting entire columns, just the used data in a column,
>>> the
>>> entire filtered data set (and the row below), the entire sheet and in
>>> each
>>> occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
>>> just the filtered list
>>>
>>> Is this a new file or a previous version one? If it's updated could you
>>> try
>>> this with a new 2007 workbook?
>>>
>>> --
>>> HTH
>>> Nick Hodge
>>> Microsoft MVP - Excel
>>> Southampton, England
>>> www.nickhodge.co.uk
>>> (E-Mail Removed)HIS
>>>
>>>
>>> "Nick Hodge" <(E-Mail Removed)> wrote in message
>>> news:Oz17%(E-Mail Removed)...
>>> > SeethaRaman
>>> >
>>> > Couple of things I've not tried is multiple filters and copying one
>>> > column. I take a look and get back
>>> >
>>> > --
>>> > HTH
>>> > Nick Hodge
>>> > Microsoft MVP - Excel
>>> > Southampton, England
>>> > www.nickhodge.co.uk
>>> > (E-Mail Removed)HIS
>>> >
>>> >
>>> > "SeethaRaman" <(E-Mail Removed)> wrote in message
>>> > news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
>>> >>I am able to consistantly repro this. I am not sure what I am missing
>>> >>here. I
>>> >> have an excel spread sheet in Excel 2007 Beta with some 500 rows and
>>> >> 8
>>> >> columns. All the 8 columns have autofilter set. I apply different
>>> >> filters
>>> >> on
>>> >> couple of columns and select the first column values using ctrl + C
>>> >> and
>>> >> paste
>>> >> it another spread sheet. I am getting all the rows instead of the
>>> >> filtered
>>> >> values only.
>>> >>
>>> >> Please let me know how I can repro this to you.
>>> >>
>>> >> SeethaRaman
>>> >>
>>> >> "Nick Hodge" wrote:
>>> >>
>>> >>> SeethaRaman
>>> >>>
>>> >>> Sorry, can't replicate...works fine here, both with standard filters
>>> >>> and
>>> >>> table ones. In fact they work the same
>>> >>>
>>> >>> --
>>> >>> HTH
>>> >>> Nick Hodge
>>> >>> Microsoft MVP - Excel
>>> >>> Southampton, England
>>> >>> www.nickhodge.co.uk
>>> >>> (E-Mail Removed)HIS
>>> >>>
>>> >>>
>>> >>> "SeethaRaman" <(E-Mail Removed)> wrote in
>>> >>> message
>>> >>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>>> >>> >I am trying to filter some data in Excel 2007 using autofilters and
>>> >>> >copy
>>> >>> >the
>>> >>> > result set data to clipboard using ctrl + C and paste it on a
>>> >>> > separate
>>> >>> > work
>>> >>> > book using ctrl + V. However, it is copying all the filtered rows
>>> >>> > data
>>> >>> > also
>>> >>> > instead of only the visible rows.
>>> >>> >
>>> >>> > This is not the desired behavior. Is there a way to achieve this
>>> >>> > as is
>>> >>> > done
>>> >>> > in Excel 2003.
>>> >>> >
>>> >>> > SeethaRaman
>>> >>>
>>> >>>
>>> >>>
>>> >
>>> >
>>>
>>>
>>>
>
>

I can send you the spread sheet that I am using. The repro steps are pretty
much straight forward.
1. Have spread sheet data in Tabular format (rows and columns). I have data
of 8 columns and 500 rows. I have columns like the following:
BugID, Bug Title, Bug Type, Priority, Assigned For, Assigned To, Status,
Opened By
2. The possible/current values in each column are:
BugID: any 4 digit numeral
Bug Title: Any text
Bug Type: "60 Day", "Non 60 Day", "Parser Dev"
Priority: "P0", "P1","P2","P3"
Assigned For: "Engineering", "Technical Review"
Assigned To: To whom the bug was assigned to (any alias, initials)
Status: "Closed", "Resolved", blank
Opened By: some name or blank
3. Now have some dummy data in those columns.
4. Sort on the first column (Bug ID).
5. Set "Auto Filter" to all the eight columns.
6. Now chose to filter on "Status" column having value "Closed". Out of 500
rows, some 350 will be selected. The status bar shows "350 of 500 records
found". Make sure that some the first 10 rows of original data are filtered
(do not have "Closed" in "Status" column).
7. Now select first 10 rows (for eg) of first column.
8. Copy and paste in another Excel sheet. You will see all the "Bug ID" s
filtered i.e., not having "Status" column set to "Closed". Basically, I
wanted to see only the first few "Bug ID"s for which the "Status" column does
not have "Closed".

Hope I am making some sense.

SeethaRaman

"Nick Hodge" wrote:

> SeethaRaman
>
> I've got no one at MS to repro this either. Can you list me detailed steps
> and we'll all try and repro. (remember things like version detail, new or
> old workbooks, etc.)
>
> If we still fail, I'll possibly get the workbook from you or put you in
> touch directly.
>
> Interestingly I came across another while testing. If you filter several
> columns when set up as a 'table' and just copy the rows the formatting style
> (bight blue, dark blue, etc) gets copied over. If you copy and paste the
> entire column the formatting gets lost
>
> Later....
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "Nick Hodge" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > SeethaRaman
> >
> > I've posted this on a beta newsgroup I have and see if I get any better
> > answers for you as I can't replicate how ever hard I try
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > www.nickhodge.co.uk
> > (E-Mail Removed)HIS
> >
> >
> > "SeethaRaman" <(E-Mail Removed)> wrote in message
> > news:17A1697C-0366-42EA-8314-(E-Mail Removed)...
> >> Sorry for getting back to you this late.
> >> The earlier one was an updated Excel sheet from Excel 2003 and opened in
> >> Compatibility mode with Excel 2007.
> >>
> >> I have created a new work book using Excel 2007, copy pasted all the data
> >> from old XLS file, saved it as XLSX file (new extension for Excel 2007).
> >> Now
> >> I apply filter (not even multiple, only one filter on a particular
> >> column)
> >> and selected first few row values from first column and pasted to a new
> >> excel. Now I again get all the rows which are filtered.
> >>
> >> This is a bug. No doubt.
> >>
> >> SeethaRaman
> >>
> >> "Nick Hodge" wrote:
> >>
> >>> SeethaRaman
> >>>
> >>> I have now tried this with more rows and multiple filters (5 rows
> >>> filtered).
> >>> I have tried selecting entire columns, just the used data in a column,
> >>> the
> >>> entire filtered data set (and the row below), the entire sheet and in
> >>> each
> >>> occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
> >>> just the filtered list
> >>>
> >>> Is this a new file or a previous version one? If it's updated could you
> >>> try
> >>> this with a new 2007 workbook?
> >>>
> >>> --
> >>> HTH
> >>> Nick Hodge
> >>> Microsoft MVP - Excel
> >>> Southampton, England
> >>> www.nickhodge.co.uk
> >>> (E-Mail Removed)HIS
> >>>
> >>>
> >>> "Nick Hodge" <(E-Mail Removed)> wrote in message
> >>> news:Oz17%(E-Mail Removed)...
> >>> > SeethaRaman
> >>> >
> >>> > Couple of things I've not tried is multiple filters and copying one
> >>> > column. I take a look and get back
> >>> >
> >>> > --
> >>> > HTH
> >>> > Nick Hodge
> >>> > Microsoft MVP - Excel
> >>> > Southampton, England
> >>> > www.nickhodge.co.uk
> >>> > (E-Mail Removed)HIS
> >>> >
> >>> >
> >>> > "SeethaRaman" <(E-Mail Removed)> wrote in message
> >>> > news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
> >>> >>I am able to consistantly repro this. I am not sure what I am missing
> >>> >>here. I
> >>> >> have an excel spread sheet in Excel 2007 Beta with some 500 rows and
> >>> >> 8
> >>> >> columns. All the 8 columns have autofilter set. I apply different
> >>> >> filters
> >>> >> on
> >>> >> couple of columns and select the first column values using ctrl + C
> >>> >> and
> >>> >> paste
> >>> >> it another spread sheet. I am getting all the rows instead of the
> >>> >> filtered
> >>> >> values only.
> >>> >>
> >>> >> Please let me know how I can repro this to you.
> >>> >>
> >>> >> SeethaRaman
> >>> >>
> >>> >> "Nick Hodge" wrote:
> >>> >>
> >>> >>> SeethaRaman
> >>> >>>
> >>> >>> Sorry, can't replicate...works fine here, both with standard filters
> >>> >>> and
> >>> >>> table ones. In fact they work the same
> >>> >>>
> >>> >>> --
> >>> >>> HTH
> >>> >>> Nick Hodge
> >>> >>> Microsoft MVP - Excel
> >>> >>> Southampton, England
> >>> >>> www.nickhodge.co.uk
> >>> >>> (E-Mail Removed)HIS
> >>> >>>
> >>> >>>
> >>> >>> "SeethaRaman" <(E-Mail Removed)> wrote in
> >>> >>> message
> >>> >>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
> >>> >>> >I am trying to filter some data in Excel 2007 using autofilters and
> >>> >>> >copy
> >>> >>> >the
> >>> >>> > result set data to clipboard using ctrl + C and paste it on a
> >>> >>> > separate
> >>> >>> > work
> >>> >>> > book using ctrl + V. However, it is copying all the filtered rows
> >>> >>> > data
> >>> >>> > also
> >>> >>> > instead of only the visible rows.
> >>> >>> >
> >>> >>> > This is not the desired behavior. Is there a way to achieve this
> >>> >>> > as is
> >>> >>> > done
> >>> >>> > in Excel 2003.
> >>> >>> >
> >>> >>> > SeethaRaman
> >>> >>>
> >>> >>>
> >>> >>>
> >>> >
> >>> >
> >>>
> >>>
> >>>
> >
> >
>
>
>

SeethaRaman

Can you send me a copy of the workbook. (Take out the obvious bits in my
email address)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"SeethaRaman" <(E-Mail Removed)> wrote in message
news:FFE749D1-8E1B-4254-8D72-(E-Mail Removed)...
>I can send you the spread sheet that I am using. The repro steps are pretty
> much straight forward.
> 1. Have spread sheet data in Tabular format (rows and columns). I have
> data
> of 8 columns and 500 rows. I have columns like the following:
> BugID, Bug Title, Bug Type, Priority, Assigned For, Assigned To, Status,
> Opened By
> 2. The possible/current values in each column are:
> BugID: any 4 digit numeral
> Bug Title: Any text
> Bug Type: "60 Day", "Non 60 Day", "Parser Dev"
> Priority: "P0", "P1","P2","P3"
> Assigned For: "Engineering", "Technical Review"
> Assigned To: To whom the bug was assigned to (any alias, initials)
> Status: "Closed", "Resolved", blank
> Opened By: some name or blank
> 3. Now have some dummy data in those columns.
> 4. Sort on the first column (Bug ID).
> 5. Set "Auto Filter" to all the eight columns.
> 6. Now chose to filter on "Status" column having value "Closed". Out of
> 500
> rows, some 350 will be selected. The status bar shows "350 of 500 records
> found". Make sure that some the first 10 rows of original data are
> filtered
> (do not have "Closed" in "Status" column).
> 7. Now select first 10 rows (for eg) of first column.
> 8. Copy and paste in another Excel sheet. You will see all the "Bug ID" s
> filtered i.e., not having "Status" column set to "Closed". Basically, I
> wanted to see only the first few "Bug ID"s for which the "Status" column
> does
> not have "Closed".
>
> Hope I am making some sense.
>
> SeethaRaman
>
> "Nick Hodge" wrote:
>
>> SeethaRaman
>>
>> I've got no one at MS to repro this either. Can you list me detailed
>> steps
>> and we'll all try and repro. (remember things like version detail, new or
>> old workbooks, etc.)
>>
>> If we still fail, I'll possibly get the workbook from you or put you in
>> touch directly.
>>
>> Interestingly I came across another while testing. If you filter several
>> columns when set up as a 'table' and just copy the rows the formatting
>> style
>> (bight blue, dark blue, etc) gets copied over. If you copy and paste the
>> entire column the formatting gets lost
>>
>> Later....
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> www.nickhodge.co.uk
>> (E-Mail Removed)HIS
>>
>>
>> "Nick Hodge" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > SeethaRaman
>> >
>> > I've posted this on a beta newsgroup I have and see if I get any better
>> > answers for you as I can't replicate how ever hard I try
>> >
>> > --
>> > HTH
>> > Nick Hodge
>> > Microsoft MVP - Excel
>> > Southampton, England
>> > www.nickhodge.co.uk
>> > (E-Mail Removed)HIS
>> >
>> >
>> > "SeethaRaman" <(E-Mail Removed)> wrote in message
>> > news:17A1697C-0366-42EA-8314-(E-Mail Removed)...
>> >> Sorry for getting back to you this late.
>> >> The earlier one was an updated Excel sheet from Excel 2003 and opened
>> >> in
>> >> Compatibility mode with Excel 2007.
>> >>
>> >> I have created a new work book using Excel 2007, copy pasted all the
>> >> data
>> >> from old XLS file, saved it as XLSX file (new extension for Excel
>> >> 2007).
>> >> Now
>> >> I apply filter (not even multiple, only one filter on a particular
>> >> column)
>> >> and selected first few row values from first column and pasted to a
>> >> new
>> >> excel. Now I again get all the rows which are filtered.
>> >>
>> >> This is a bug. No doubt.
>> >>
>> >> SeethaRaman
>> >>
>> >> "Nick Hodge" wrote:
>> >>
>> >>> SeethaRaman
>> >>>
>> >>> I have now tried this with more rows and multiple filters (5 rows
>> >>> filtered).
>> >>> I have tried selecting entire columns, just the used data in a
>> >>> column,
>> >>> the
>> >>> entire filtered data set (and the row below), the entire sheet and in
>> >>> each
>> >>> occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v)
>> >>> was
>> >>> just the filtered list
>> >>>
>> >>> Is this a new file or a previous version one? If it's updated could
>> >>> you
>> >>> try
>> >>> this with a new 2007 workbook?
>> >>>
>> >>> --
>> >>> HTH
>> >>> Nick Hodge
>> >>> Microsoft MVP - Excel
>> >>> Southampton, England
>> >>> www.nickhodge.co.uk
>> >>> (E-Mail Removed)HIS
>> >>>
>> >>>
>> >>> "Nick Hodge" <(E-Mail Removed)> wrote in
>> >>> message
>> >>> news:Oz17%(E-Mail Removed)...
>> >>> > SeethaRaman
>> >>> >
>> >>> > Couple of things I've not tried is multiple filters and copying one
>> >>> > column. I take a look and get back
>> >>> >
>> >>> > --
>> >>> > HTH
>> >>> > Nick Hodge
>> >>> > Microsoft MVP - Excel
>> >>> > Southampton, England
>> >>> > www.nickhodge.co.uk
>> >>> > (E-Mail Removed)HIS
>> >>> >
>> >>> >
>> >>> > "SeethaRaman" <(E-Mail Removed)> wrote in
>> >>> > message
>> >>> > news:62870C78-F2C7-4D75-AD99-(E-Mail Removed)...
>> >>> >>I am able to consistantly repro this. I am not sure what I am
>> >>> >>missing
>> >>> >>here. I
>> >>> >> have an excel spread sheet in Excel 2007 Beta with some 500 rows
>> >>> >> and
>> >>> >> 8
>> >>> >> columns. All the 8 columns have autofilter set. I apply different
>> >>> >> filters
>> >>> >> on
>> >>> >> couple of columns and select the first column values using ctrl +
>> >>> >> C
>> >>> >> and
>> >>> >> paste
>> >>> >> it another spread sheet. I am getting all the rows instead of the
>> >>> >> filtered
>> >>> >> values only.
>> >>> >>
>> >>> >> Please let me know how I can repro this to you.
>> >>> >>
>> >>> >> SeethaRaman
>> >>> >>
>> >>> >> "Nick Hodge" wrote:
>> >>> >>
>> >>> >>> SeethaRaman
>> >>> >>>
>> >>> >>> Sorry, can't replicate...works fine here, both with standard
>> >>> >>> filters
>> >>> >>> and
>> >>> >>> table ones. In fact they work the same
>> >>> >>>
>> >>> >>> --
>> >>> >>> HTH
>> >>> >>> Nick Hodge
>> >>> >>> Microsoft MVP - Excel
>> >>> >>> Southampton, England
>> >>> >>> www.nickhodge.co.uk
>> >>> >>> (E-Mail Removed)HIS
>> >>> >>>
>> >>> >>>
>> >>> >>> "SeethaRaman" <(E-Mail Removed)> wrote in
>> >>> >>> message
>> >>> >>> news:E8B7C8BD-DBB2-48C8-80FC-(E-Mail Removed)...
>> >>> >>> >I am trying to filter some data in Excel 2007 using autofilters
>> >>> >>> >and
>> >>> >>> >copy
>> >>> >>> >the
>> >>> >>> > result set data to clipboard using ctrl + C and paste it on a
>> >>> >>> > separate
>> >>> >>> > work
>> >>> >>> > book using ctrl + V. However, it is copying all the filtered
>> >>> >>> > rows
>> >>> >>> > data
>> >>> >>> > also
>> >>> >>> > instead of only the visible rows.
>> >>> >>> >
>> >>> >>> > This is not the desired behavior. Is there a way to achieve
>> >>> >>> > this
>> >>> >>> > as is
>> >>> >>> > done
>> >>> >>> > in Excel 2003.
>> >>> >>> >
>> >>> >>> > SeethaRaman
>> >>> >>>
>> >>> >>>
>> >>> >>>
>> >>> >
>> >>> >
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>