Excel worksheet ---> PPT (paste link)

  • Thread starter Thread starter Guest
  • Start date Start date
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?
Click to expand...

Interesting.

On pasting, I get a PPT table as default. Ugly, distorted, no gridlines. But
color.

If I use the clipboardwhatsit icon and tell it "Excel Table, Entire Workbook" I
get a better-formatted table but still no gridlines. Still color.

And like Epinn, if I doubleclick to activate it then click off again, THEN the
gridlines appear.

While at it, I also created a chart and copy/pasted that. Trash. It's all
distorted. It tells me TWICE that the file contains macros (well, it does, but
need we be so hyper about it?) then gives me a chart that's flatter'n' a
armadillo on a Texas highway. Not totallytortillafied but working on it.

Again, if I use the icon at lower right and choose Picture of Chart rather than
Whole chart, the chart corrects itself to full size. But of course, then it's
a picture, not a chart and can't be edited.

As ever, PasteSpecial/Link gives visually pleasing results w/o having to do all
the dancing around. OTOH, even it requires you to activate the pasted results
once before you see the grid lines.

This is all in 2003. smAcktiveX?
 
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
 
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?
Click to expand...

That's correct. The physical printer doesn't need to be installed, just the driver
(and the driver should be set as the default printer)
 
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
 
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."
Click to expand...

It appears to be a bug in 2003. Or at least a bug that appears on both of our systems.
 
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
 
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) ......
Click to expand...

I'm not sure how much of is passion and how much is grumpiness over features that we have to
work with every day, but that don't quite work. ;-)

But thank you kindly all the same.
 
Back
Top