Publisher 2003 & Excel

[Bob L]

I was hoping that MS would allow me a way to link some
cells from an Excell worksheet into Publisher 2003 and
not have a border around each cell print in the Publisher
page. Can anyone figure out a way to do this or a work
around? This is driving me crazy. Thanks for trying.

 

[°°°MS°Publisher°°°]

Bob you are very easily driven crazy, and to say it in public really proves
your need for therapy.

Have you switched off the Gridlines in Excel before you copy and paste it?

We are only to happy to help with any facet of Publisher, so instead of
being driven crazy, post here for some assistance.

--

 

[Brian Kvalheim - [MS MVP]]

Hi °°°MS°Publisher°°° ([email protected]),
in the Microsoft® newsgroups
you posted:

|| Have you switched off the Gridlines in Excel before you copy and
|| paste it?

David, in my experience, the gridlines remain present even after turning
them off in Excel when using Publisher 2002 and 2003. This was NOT the case
when using Publisher 2000 and older.

--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[°°°MS°Publisher°°°]

Brian K you were trying to make me think I was going mad - well the news is
all bad for you, because I have no such issue when printing an Excel 2003
spreadsheet in Publisher 2003. Works perfectly in all ways.

I switch off the Grid Lines in Excel, copy and paste to Publisher 2003 as
straight paste or as OLE and print, no issue at all, no gridlines.

--

 

[Brian Kvalheim - [MS MVP]]

Hi °°°MS°Publisher°°° ([email protected]),
in the Microsoft® newsgroups
you posted:

|| Brian K you were trying to make me think I was going mad - well the
|| news is all bad for you, because I have no such issue when printing
|| an Excel 2003 spreadsheet in Publisher 2003. Works perfectly in all
|| ways.
||
|| I switch off the Grid Lines in Excel, copy and paste to Publisher
|| 2003 as straight paste or as OLE and print, no issue at all, no
|| gridlines.

Sweet! They must have fixed it since the beta. I just assumed it wasn't
addressed. That is great news David!

--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Brian Kvalheim - [MS MVP]]

I too get the gridlines when using the Insert > Object > Create New. I
posted this as a bug as well during the beta stage.

I guess I never tried Copy/Paste as David has mentioned. The Insert > Object

Create New didn't show gridlines in Publisher 2000 and older.

--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Brian Kvalheim - [MS MVP]]

It might explode.

--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Bob L]

Sorry did not get back to post earlier.
I have tried to turn off gridlines, tried that 1st. I am not copying and pasting, I am pasting a "Link"
I have found that if I fill the spreadsheet with white color the gridlines do not show up. This is not the greatest
work around thouhg. When printing on a color laser printer the white is usually a different color than the "white" paper.

I can't beleive this was allowed, I also posted this in the Beta version, almost seems that it was a waste of time to provide feedback on the beta.

 

[Bob L]

Taking your suggestion I tried this on my laptop which did not have the beta version installed. I still get the grid lines. This computer is running XP and had Office 2000 then upgraded completly to Office 2003. Other machine Windows 2000 had beta and did a full upgrade. Both copy gridlines. Gridlines are off. I tried formatting gridlines to no lines, tried turning them on then off, nothing seems to work. What are you doing or running that I am not

----- °°°MS°Publisher°°° wrote: ----

Well Bob, I would say, that because you has the beta installed, it still has some files of the Beta on your hard drive
I recently did a full as in to a complete blank hard drive install, and installed the full version of Office 2003 and Publisher 2003 and I have zero issues with the grid lines. That is by inserting a link or copying and pasting

The graphic below shows at the top it shows a Copy and PASTE LIN
and the bottom is a straight Copy and Paste, but neither print the grid lines
I tried on my Canon inkjet and Kyocera laser printer and no grid lines

 

[°°°MS°Publisher°°°]

Bob I have Windows XP with all updates, Office 2003, Publisher 2003,
Publisher 97 and usual other stuff like OE and IE, otherwise a very benign
system with no fancy software on. Besides my all my Serif applications,
OmniPro 14 and heaps of mapping and geo-software. I have no virus software
or any other junk and *definitely* no Symantec troublesome garbage.
Have a substantial amount of hardware connected, but nothing that would
influence the issue we are discussing.

--

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

When printing on a color laser printer the white
is usually a different color than the "white" paper.

As I have never used Publisher with a dye sublimation printer (the only type
of which I know where the printer can print white), I have never known
whether Publisher will print a white area on the page as an absence of ink,
or as a white ink. I would have been inclined to say that it would be set
up as an absence of ink (unless spot colours were used as well) - have you
tried doing this with Publisher?

 

[Bob L]

I have tried this in publisher using a logo that was created using publisher. The whole area that was supposed to be white was not, stood out as a off white or bone color when printed on HP's bright white laser paper. Looks white on screen

----- Ed Bennett wrote: ----

After managing to set up OE-QuoteFix on his new PC, Ed reads a messag

When printing on a color laser printer the whit
is usually a different color than the "white" paper

As I have never used Publisher with a dye sublimation printer (the only typ
of which I know where the printer can print white), I have never know
whether Publisher will print a white area on the page as an absence of ink
or as a white ink. I would have been inclined to say that it would be se
up as an absence of ink (unless spot colours were used as well) - have yo
tried doing this with Publisher

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I have tried this in publisher using a logo that was created using
publisher. The whole area that was supposed to be white was not,
stood out as a off white or bone color when printed on HP's bright
white laser paper. Looks white on screen.

That sounds like an issue in the logo file - I doubt if you printed it on
coloured paper, that the area would come out the same colour (brighter than
the colour of the paper).
I would suggest a printer driver upgrade, or changing your colour mode to
overcome this issue.

 

[Bob L]

Ed,
I had thought about that. But did not try, I converted the logo from a jpeg to a png file and made the "white" area transparent. This resolved the problem immediately and consistently, no matter what shade of white paper I printed on.

Still can’t get rid of the grey grid lines from the spreadsheet after importing from Excel

----- Ed Bennett wrote: -----

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I have tried this in publisher using a logo that was created using
publisher. The whole area that was supposed to be white was not,
stood out as a off white or bone color when printed on HP's bright
white laser paper. Looks white on screen.

That sounds like an issue in the logo file - I doubt if you printed it on
coloured paper, that the area would come out the same colour (brighter than
the colour of the paper).
I would suggest a printer driver upgrade, or changing your colour mode to
overcome this issue.