Excel links in Word not printing colors (XP)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick G. - 12 Jan 2004 19:06 GMT

Gretting All,

Office XP SP2
Windows XP SP1 and all critical patches
Windows 2000 SBS Server SP4 and all critical patches

We have a Word doc this contains a decent amount of Excel data.
Some of the data comes from Excel links, others are just pasted as picture,
etc...

Everything is quite fine with the data and formatting when the document is
open on any PC.
The problem seems to be with a table pasted from Excel into Word as a
Pircture w/ Link.
When that page of the document or even the entire doc is printed the colors
in that particular table do not get printed.

However, if the link is broken the colors print as expected. The breaking of
the link of course defeats the purpose of linking the table in the first
place....

So is there any thing that can be done to fix this?

Thanks,
Patrick

Reply to this Message

Paul Cundle - 12 Jan 2004 20:41 GMT

Sorry I can't be too specific, but I recall a similar question being asked
recently in this group (last month or so) so a search on groups.google.com
might do the trick.

I think you need to right click on the object in Word to edit the
properties. When it opens in Excel, look in Page Setup and make sure
settings such as B&W, Draft etc are as appropriate. Then save the file and
hopefully all will be well within your .document.

Paul C,

Signature

> Gretting All,
>
[quoted text clipped - 21 lines]
> Thanks,
> Patrick

Reply to this Message

Patrick G. - 12 Jan 2004 22:00 GMT

Thanks Paul.

Unfortunately I have scoured the Google Groups for hours. I found many tips
and such that I thought would work but have yet to find the one that
actually does work.
An added thing to what I posted below is that this object isn't a graph at
all its just a named range of cells with condional formatting.

The users of the documents are just getting weary of breaking links to
print and then resetting them so the data stays correct in the docs.

Anyone else have some insight???

Thanks.

> Sorry I can't be too specific, but I recall a similar question being asked
> recently in this group (last month or so) so a search on groups.google.com
[quoted text clipped - 31 lines]
> > Thanks,
> > Patrick

Reply to this Message