Excel worksheet ---> PPT (paste link)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(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
 
(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?
Click to expand...

I always get whatever's showing in Excel. If it's set to show grids, I get
grids in PPT. This is set in Tools, Options (general, I think)
(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?
Click to expand...

That depends on what you need to do.

If it's just to display the static information in PPT, you don't even need the
Excel file. When you paste/linked, you also got a WMF picture of the Excel
data. You can display or print that w/o needing Excel or the XLS file it's
linked to.

If you want to activate/edit the Excel content, then you'll need the XLS file
and Excel.
 
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
 
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
 
#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
 
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
 
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
 
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
Click to expand...

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.
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>
Click to expand...

With good questions.

That makes it interesting.
 
#2 follow-up post

See, I told you I could go on and on.
Click to expand...

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

Well, try it w/o the "As icon' setting and follow up on Kathy's question, a good one.
 
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
 
Please refer to my reply to Kathy's post.

Epinn

Steve Rindsberg said:
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
================================================
Click to expand...
 
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
 
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
 
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.
Click to expand...

Out of curiosity, since I haven't tried it and am too lazy to ... it won't work
even if MODI is set to make MDI files (which are or can be color)?
 
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.
Click to expand...

No problem. But you have to put up with me when I don't know the answer, and in this
case I don't. Hello, Echo(echoechoechoecho....)
 
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
 
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
 
Hmmm... Haven't tried that myself either... Got any round tuits we can
trade?
Click to expand...

Happens Excel is sitting open on a machine with MODI installed and set to MDI.

What needs tested?
Steps2Repro?
 
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.
Click to expand...

You do NOT want to trust my memory. <g>
But Glenna will probably wander through here and see this sooner or later.
 
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
 
Back
Top