PC Review


Reply
Thread Tools Rate Thread

How do I make colors appear correctly when linking excel to pub?

 
 
=?Utf-8?B?S3Jpcw==?=
Guest
Posts: n/a
 
      18th Sep 2006
Hi, when I link an excel table to a publisher document (for a client report),
the number that are in red in the excel spread sheet appear red in the
publisher document, until I print it. Then, the number appear black. Why?
Thank you -- any help would be greatly appreciated!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      18th Sep 2006
In Excel there is a print setting for Black and White... File -> Page Setup
-> Black and White
--
HTH...

Jim Thomlinson


"Kris" wrote:

> Hi, when I link an excel table to a publisher document (for a client report),
> the number that are in red in the excel spread sheet appear red in the
> publisher document, until I print it. Then, the number appear black. Why?
> Thank you -- any help would be greatly appreciated!

 
Reply With Quote
 
=?Utf-8?B?S3Jpcw==?=
Guest
Posts: n/a
 
      18th Sep 2006
Jim, thanks for your reply. My problem is that a "negative" in excel appears
as red in a table. I link this table to a publisher doc, and the negative
numbers in the table continue to 'look' red on the screen. However, when I
PRINT the publisher document, all of the numbers, including those in the
negative, print black. So, if a client looks at this table in the printed
publisher report, he will see (-$1,074) in black instead of red. It only
appears red on the screen. Other colors in the publisher report (header, etc)
are printing in color just fine. Any ideas? Thanks again. Kris

"Jim Thomlinson" wrote:

> In Excel there is a print setting for Black and White... File -> Page Setup
> -> Black and White
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Kris" wrote:
>
> > Hi, when I link an excel table to a publisher document (for a client report),
> > the number that are in red in the excel spread sheet appear red in the
> > publisher document, until I print it. Then, the number appear black. Why?
> > Thank you -- any help would be greatly appreciated!

 
Reply With Quote
 
=?Utf-8?B?Y21hcmluYWNAZmlncGFydG5lcnMuY29t?=
Guest
Posts: n/a
 
      19th Sep 2006
Kris:

Try changing your default printer. I had mine on FAX and it was the reason
my colors would not work. If you have AdobeAcrobat and can print into Adobe
file, that would be a good default option.

Good Luck.

"Kris" wrote:

> Jim, thanks for your reply. My problem is that a "negative" in excel appears
> as red in a table. I link this table to a publisher doc, and the negative
> numbers in the table continue to 'look' red on the screen. However, when I
> PRINT the publisher document, all of the numbers, including those in the
> negative, print black. So, if a client looks at this table in the printed
> publisher report, he will see (-$1,074) in black instead of red. It only
> appears red on the screen. Other colors in the publisher report (header, etc)
> are printing in color just fine. Any ideas? Thanks again. Kris
>
> "Jim Thomlinson" wrote:
>
> > In Excel there is a print setting for Black and White... File -> Page Setup
> > -> Black and White
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Kris" wrote:
> >
> > > Hi, when I link an excel table to a publisher document (for a client report),
> > > the number that are in red in the excel spread sheet appear red in the
> > > publisher document, until I print it. Then, the number appear black. Why?
> > > Thank you -- any help would be greatly appreciated!

 
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
Linking Query to Excel make DB Read Only Chuck W Microsoft Access 0 16th Jul 2009 02:22 PM
How do you make Excel use CMY colors instead of RGB colors? Jim Benet Microsoft Excel Setup 5 10th Oct 2008 02:16 PM
linking to excel, my fieldnames from excel won't import correctly Ruth Microsoft Access External Data 0 9th Oct 2008 10:38 AM
How can I make Excel save Unicode CSV data correctly? FooBarBaz Microsoft Excel Misc 0 17th Jul 2008 03:08 AM
Make Excel's ERF function work correctly for negative arguments (. =?Utf-8?B?Sm9obiBUcmVuaG9sbWU=?= Microsoft Excel Crashes 6 4th Aug 2005 04:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:44 AM.