There is an odd quirk between Excel and Outlook in that if you copy a range
of filtered data and past the table in an Outlook e-mail and send it out, in
the e-mail sent all of the hidden rows are invisible, but when the recipient
replies or forwards the e-mail, all of the hidden cells are exposed,
defeating the puprose of filtering and only included a small subset of data.

I know there is a button to copy only visible cells, but is there a way
through excel settings or VBA to completely disable this functionality and
AWAYS only select visible rows?

It's not Outlook doing this but apparently Excel still copies the
non-visible data to the targeted application. In your case that is Outlook
but it could be any other application as well.

That would make it an Excel question, doesn't it? ;-)
Better ask this question in an Excel newsgroup then.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

-----

"Shawn" <(E-Mail Removed)> wrote in message
news:F6C08A6D-958F-48E0-B48B-(E-Mail Removed)...
> There is an odd quirk between Excel and Outlook in that if you copy a
> range
> of filtered data and past the table in an Outlook e-mail and send it out,
> in
> the e-mail sent all of the hidden rows are invisible, but when the
> recipient
> replies or forwards the e-mail, all of the hidden cells are exposed,
> defeating the puprose of filtering and only included a small subset of
> data.
>
> I know there is a button to copy only visible cells, but is there a way
> through excel settings or VBA to completely disable this functionality and
> AWAYS only select visible rows?
>

I posted the issue in Excel as well because I'm not sure if it's Excel
specific, Outlook specific, or an issue across Microsoft applications
regardless of which one you paste into.

After posting I found this (XL2000 related but clearly the problem exists in
later versions) http://support.microsoft.com/kb/245541. If that's their best
solution, there isn't a way to turn off the functionality.

"Roady [MVP]" wrote:

> It's not Outlook doing this but apparently Excel still copies the
> non-visible data to the targeted application. In your case that is Outlook
> but it could be any other application as well.
>
> That would make it an Excel question, doesn't it? ;-)
> Better ask this question in an Excel newsgroup then.
>
> --
> Robert Sparnaaij [MVP-Outlook]
> Coauthor, Configuring Microsoft Outlook 2003
> http://www.howto-outlook.com/
> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>
> http://www.msoutlook.info/
> Real World Questions, Real World Answers
>
> -----
>
> "Shawn" <(E-Mail Removed)> wrote in message
> news:F6C08A6D-958F-48E0-B48B-(E-Mail Removed)...
> > There is an odd quirk between Excel and Outlook in that if you copy a
> > range
> > of filtered data and past the table in an Outlook e-mail and send it out,
> > in
> > the e-mail sent all of the hidden rows are invisible, but when the
> > recipient
> > replies or forwards the e-mail, all of the hidden cells are exposed,
> > defeating the puprose of filtering and only included a small subset of
> > data.
> >
> > I know there is a button to copy only visible cells, but is there a way
> > through excel settings or VBA to completely disable this functionality and
> > AWAYS only select visible rows?
> >
>