1.

Solve : Excel into WordPerfect prints black?

Answer»

Hopefully someone can help me with this - when I paste an excel spreadsheet into WordPerfect it prints out black -- any ideas how to FIX this?If have Excel, then you must have Word.  So, why are you using WordPerfect?Because that's the program my boss has used for YEARS and he doesn't want to change at this point because he's so used to it. Most things we are able to work around - this is just one that is an issue. And it's only an issue on my computer - not his. If he pastes a spreadsheet from Excel into WordPerfect, it doesn't print out black. But if I do it from my computer, it does. It just doesn't make sense to me. (And for the record, I would rather be using Word, but I've gotta use what I'm being told to work with.) Thanks!Let's clarify a few points.  Do both you and your boss have Excel and WordPerfect installed on your computers?  If so, do you both have the same version of Excel and WordPerfect?  If the latter is true, have you compared settings for margins, etc. in both your computers to verify they are the same?

How large is the spreadsheet?  How many rows and columns?  Why copy it to a word processing file?  Is it being merged with text created in the word processor?  If so, is the text a major portion of the final product or is the spreadsheet content the major portion?  If the final product is mainly the spreadsheet data, has straight use of Excel ever been considered?  In other words, instead of copying a spreadsheet into WordPerfect, just add some text to Excel and print the spreadsheet from Excel.

Are both computers connected to the same printer, and that's the printer you both use to print the WordPerfect file?

If you copy a WordPerfect file with Excel content from the boss's computer to yours, will it print correctly? We both have the same versions - with the same updates & "patches" - of Excel & WordPerfect. His computer is the "main" computer & mine is "networked" off of his. In other words, everything I do is saved to his computer & not my own hard drive. We have tried different printers in the office (we have 3) and it doesn't matter which one I print to, it still comes out black.

As far as the spreadsheets, they are relatively small but vary in size.  Usually anywhere between a 4 - 6 column and 10 - 30 row size.  We do data analysis in the Excel spreadsheet and paste it into the WP document, which is our report format. The WP document can be anywhere from 30 - 100 pages with 1 - 10 or more spreadsheets -- it just depends on the analysis being completed. I completely agree it would be easier to use Word instead of WP but all of his reports are formatted in WP and the formatting completely screws up when CONVERTED to Word so he just doesn't want to GO there.  What we end up doing for the reports I complete on my computer is -- do everything but the spreadsheets & then open them on his computer to paste the spreadsheets in - which works but it's just annoying that I can't complete the entire report on my computer!

We've tried looking at various settings but maybe there's something that we are just missing? Thanks again for trying to help with this!!If I had WP on my computer, I could test this since I do have Excel.  But, I don't have WP. 

I upload a monthly newsletter to a website of a church of which I am a member.  The newsletter is usually 10 - 12 pages long.  It is created in WP by the office manager at the church but she converts it to Word before sending it to me.  That seems to work OK.  I'm not absolutely sure what version of WP she has; I think it may be version 10.  And, she has MS Office 2003.

Would the boss be receptive to switching to Word if the formatting issues could be resolved?  Maybe the procedure you used for attempting to convert to Word was not the best way to do it.  Here's one reference on converting older versions of WP to Word: http://office.microsoft.com/en-us/word/HP052742911033.aspx

I don't know what else to suggest.  Perhaps someone else will chime in with some ideas.I don't know -- I've only been here a couple of months and I've been "gently" trying to drag him around so I don't know if it would work or not. But I'll TAKE a look at the site you suggested and see what happens! Thanks for your input!Drag him kicking and screaming...usually works for me.



Discussion

No Comment Found