Excel worksheet ---> PPT (paste link)

[Epinn]

(1) After I have chosen "paste link," sometimes I get a table with grid
lines and sometimes I get just rows and columns. Why is this happening? How
can I get a table?

(2) I assume I should have the Excel worksheet and the PPT presentation in
the same folder for the show to run. Is it necessary to have Excel software
installed in the PC where the show runs?

Appreciate advice.

Epinn

 

[Epinn]

Thank you, Steve. I appreciate the fact that you are clear, detailed and try
to cover a few different angles; case in point - reply to #2. I am all clear
now. I didn't know WMF was at work.

Re: #1, I still don't know what I have missed and I am still experimenting.
I used the same worksheet, same settings and tried to paste special (link) to
different slides of the same PPT presentation. The effect was "now you see
it, now you don't." I did the following to display the gridlines in PPT.

Right-click on the object > Linked worksheet object > Convert > Tick display
as icon > Okay

Then, right-click on the icon > Untick display as icon

All this just to display the gridlines.

Under Excel, I checked tools, options, view and I saw that the gridlines box
was ticked.

I am at a loss. Gridlines should show all the time with the above settings,
right?

By the way, I appreciate the fact that you read follow-up posts. You know I
can go on and on ...... <g>

Epinn

 

[Kathy Jacobs]

I know hits is going to sound like an unrelated question, but it really
isn't...

What is your default printer set to? Is it a local printer? Some parts of
Excel spreadsheets are affected by whether you have a color or black and
white printer, and I am wondering if the gridlines are changing due to a
change in printer....

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Epinn]

#2 follow-up post

See, I told you I could go on and on.

Another way (easier) to show gridlines is to right-click the object and then
click update link.

The third way is to double click on the object and go to Excel and change
something. I am not sure if this puts the gridlines in PPT *every time*.

Epinn

 

[Epinn]

Kathy,

I am not on any network. My printer is not set up although connected to the
CPU. When I click print, the status is "idle."

Epinn

 

[Kathy Jacobs]

What do you mean by "not set up"? If you are running PPT, it is always a
very good idea to have a default printer selected... whether you actually
have one connected or not.

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Epinn]

Kathy,

Thank you for your posts. You asked good questions. Some time ago, I think
I read something along the line that PPT looks for a printer driver for it to
work. Please correct me if I am wrong.

I don't really know what's going on with the print feature. I always have
my printer connected to my desk top but I can't remember if I have ever used
it. When I click print, the dialogue box shows the following.

Name: Microsoft Office Document Image Writer
Status: Idle
Driver: Microsoft Office Document Image Writer Driver
Where: Microsoft Document Imaging Writer Port

I never paid attention to this. When I click "ok" (i.e. to print), the
"save as" dialogue box (not sure if this is the proper term) shows. When I
click "find printer," the message "the directory service is currently
unavailable" displays. Frankly, I have no idea what all this is about.

Anyway, I bought a new printer and may connect it to my CPU when I am not
too busy posting questions. <g> When my new printer is up and running, I'll
test the gridlines again and report back.

Please refer to my follow-up post #2. I wonder why clicking "update link"
puts the gridlines in place.

Thanks for helping me.

Epinn

 

[Epinn]

Please refer to my reply to Kathy's post.

Epinn

Well .. hmm. There's one difference. I've never used Display as Icon. Try leaving
that unticked as a start. Why it should have any effect, I don't know.


With good questions.

That makes it interesting.




-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Epinn]

Steve,

Sorry, forgot to say this in my last post. In case you are looking for an
interesting question, I think I may have one. Please refer to my last post
under the thread "How to loop sound with a looped presentation." Everything
is working fine now. But I don't understand why it would work. Yes, I ask
questions even when things work. Why? I really want to learn. Thank you
for putting up with me.

Epinn

 

[Kathy Jacobs]

What it looks like to me is that you have the Microsoft Office Document
Image Writer (MODI) set as your default printer. That won't let you do what
you want with your Excel stuff. What I would do is to go to your Start Menu
for your computer, and drag up and over to Printers and Faxes. See which
other printers you have installed besides the MODI and make one of them
(hopefully a color one) your default printer. Then try to do your paste from
Excel again.

As to why you get gridlines sometimes and not others? No clue. But, like I
said, it might be related to the printer you have chosen - MODI really isn't
a good choice as far as PPT is concerned.

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Epinn]

Steve,

I greatly appreciate everyone's help and time. There is no "putting up"
whatsoever. Glenna Shaw is the one who provided the perfect solution (i.e.
custom show and kick-off slide). I don't want to bother her even though I
know her e-mail address and she probably recalls the name "Epinn." In case
you run into Glenna at PPT live or other events, I wonder if you can ask her.


Always try to get to the bottom of things especially when they are
interesting ......

Stay tuned for the printer/Excel/PPT issue. May take me a while.

Epinn

 

[Kathy Jacobs]

Hmmm... Haven't tried that myself either... Got any round tuits we can
trade?

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Kathy Jacobs]

Sorry - been gone all day. If it isn't too late, create an Excel file with
color content and gridlines on. Save the Excel file. Set the MODI as the
default printer. Copy and paste it to the PPT file. What do you get?
Gridlines or no? Color or no?

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Epinn]

When I first posted, I focused on paste special > paste **link** where I had
the problem. Today I tried paste special > **paste**. When I double click
on the object after pasting, I see something identical to Excel. Click once
outside the worksheet, I see a table with gridlines and eight white dots.
Click again I see a table with gridlines and no white dots. It seems to be
okay with paste special > paste. The problem is with paste link.

Up to this point, all my posts are based on a stand alone desk top and MODI.

I also tried paste special > paste link on a network. It was fine on June
22 but not on June 29.

Right now, I have nothing other than MODI on my desktop. If I understand
Kathy correctly, I don't need to connect the printer to the CPU. Is it good
enough if I just install a printer driver and test again?

Thank you!

Epinn

 

[Epinn]

I installed the printer driver. No luck, no improvement. One sure way to
get the gridlines is to right click on the object and then choose "update
link."

Epinn

 

[Epinn]

Thank you both for going out of your way to help solve the problem. What I
get out of this forum is more than guidance. I really appreciate the virtues
like patience, perseverance, attention to details, passion to improve (the
add-ins created by MVP's are proof) ......

Epinn