When copying data from Excel and selecting paste special - picture (windows
or enhanced metafile) into my word doc, all text is going to black and white?
Does anyone know where the setting is that adjusts this? This only occurs
on my computer and no one elses in my office.

There is a setting in Excel that might be doing this. In Excel, go to File |
Page Setup. On the Sheet tab, make sure that "Black and white" is not
checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
When copying data from Excel and selecting paste special - picture
(windows
or enhanced metafile) into my word doc, all text is going to black and
white?
Does anyone know where the setting is that adjusts this? This only
occurs
on my computer and no one elses in my office.

Not checked. It's only the text color that goes to black (if cells are
filled with a color, the fill color stays but the text goes to black)

"Suzanne S. Barnhill" wrote:

There is a setting in Excel that might be doing this. In Excel, go to File |
Page Setup. On the Sheet tab, make sure that "Black and white" is not
checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
When copying data from Excel and selecting paste special - picture
(windows
or enhanced metafile) into my word doc, all text is going to black and
white?
Does anyone know where the setting is that adjusts this? This only
occurs
on my computer and no one elses in my office.

Ah, well that's different. I suspect that's conditional formatting, which
Word doesn't support, or which the Picture format doesn't support.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
Not checked. It's only the text color that goes to black (if cells are
filled with a color, the fill color stays but the text goes to black)

"Suzanne S. Barnhill" wrote:

There is a setting in Excel that might be doing this. In Excel, go to
File |
Page Setup. On the Sheet tab, make sure that "Black and white" is not
checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
When copying data from Excel and selecting paste special - picture
(windows
or enhanced metafile) into my word doc, all text is going to black and
white?
Does anyone know where the setting is that adjusts this? This only
occurs
on my computer and no one elses in my office.

I can take the same two files to 10 different computers and it pastes fine
(with color)

"Suzanne S. Barnhill" wrote:

Ah, well that's different. I suspect that's conditional formatting, which
Word doesn't support, or which the Picture format doesn't support.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
Not checked. It's only the text color that goes to black (if cells are
filled with a color, the fill color stays but the text goes to black)

"Suzanne S. Barnhill" wrote:

There is a setting in Excel that might be doing this. In Excel, go to
File |
Page Setup. On the Sheet tab, make sure that "Black and white" is not
checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Lossofcolor" wrote in message
...
When copying data from Excel and selecting paste special - picture
(windows
or enhanced metafile) into my word doc, all text is going to black and
white?
Does anyone know where the setting is that adjusts this? This only
occurs
on my computer and no one elses in my office.