Copying from excel and pasting as a metafile in powerpoint

[JG]

All of a sudden, when I copy a range of cells from Excel 2007 and paste as a
metafile into Powerpoint 2007, the excel gridlines are also copied. This
never happened prior to a few days ago. I know I can hide the grid lines in
excel but that is inconvenient and I want to know why the sudden change and
if there is a way to correct it. I do know that an office update was
installed four days ago,.which may just be a coincidence.

Does anyone know?

 

[JG]

Thanks but yes it is installed.

I think SP2 was supposed to correct something along these lines. Do you have
it installed yet?

Office button | PowerPoint Options | Resources.

If SP2 is installed it'll say so at the bottom of the dialog box

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

 

[Echo S]

I think SP2 was supposed to correct something along these lines. Do you
have
it installed yet?

Office button | PowerPoint Options | Resources.

If SP2 is installed it'll say so at the bottom of the dialog box

I think SP2 corrected the bug where, if the gridlines were showing in Excel,
they weren't pasted into PPT. Made it more WYSIWYG, which is apparently what
people expect.

So basically, you could say SP2 is causing the problem. (But it's
really fixing a bug. That's my understanding, anyway. I'd have to look it up
to be sure.)

Hide the gridlines in Excel before copying.

 

[John]

I think SP2 was supposed to correct something along these lines. Do you
have
it installed yet?

Office button | PowerPoint Options | Resources.

If SP2 is installed it'll say so at the bottom of the dialog box

I think SP2 corrected the bug where, if the gridlines were showing in Excel,
they weren't pasted into PPT. Made it more WYSIWYG, which is apparently what
people expect.

So basically, you could say SP2 is causing the problem. (But it's
really fixing a bug. That's my understanding, anyway. I'd have to look it up
to be sure.)

Hide the gridlines in Excel before copying.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

I have exactly the same issue. I don't think I have SP2, I have not installed anything in the last week. After years of Paste Special, enhanced metafile, with no gridlines, suddenly gridlines when paste into PPoint. Only way to get rid of them is to take them out prior to "copy" in Excel. This is not a great solution. It should work as it used to work. On my other computer, it works as usual (no gridlines). The answers by Mr. Rindsberg are not really responsive, more of a guess than facts. Though thanks for trying. Does anyone have a solution to this issue that does not involve band aids - ie, a solution that reverts to previous mode of operation. Thanks.

 

[Echo S]

anything in the last week.

Go to Office Button | PowerPoint Options | Resources

Beneath "about Microsoft Office PowerPoint 2007" it'll tell you what SP
level you're
at, if any, just before "MSO".

I'm guessing that you have SP2 or one of the updates that went into it.

I've just doublechecked this on two systems; the one with SP1 doesn't
paste the
gridlines from Excel, the one with SP2 does.

Service Pack 2 for Office 2007 can be uninstalled. I assume that
uninstalling SP2 would take the user back to SP1 behavior.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
Enter the Create a Spark Presentation Contest here!
http://office.microsoft.com/en-us/templates/FX102395221033.aspx

 

[Echo S]

Probably, but unless MS sees this as a bug rather than a deliberate
change,
it'll get changed back in another SP or fix later. Unless it's important
enough to forego any further patches, it seems like something OP'll have
to
live with, no?

Possibly. Probably. Hard to say.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
Enter the Create a Spark Presentation Contest here!
http://office.microsoft.com/en-us/templates/FX102395221033.aspx

 

[ZK]

Have just written down how to do it, tried to post it and got an error from
MS ...

 

[ZK]

Excel 2007: open your workbook, select the worksheets from which you want to
copy a range, click Page Layout, in Sheet Options, under Gridlines, unchek
the box at view. The gridlines in the selected sheets will disappear. Ungroup
the worksheets.

Go sheet-by-sheet: click far away from the range you want to copy (if not,
the cell with a thick black border will show in your pasted copy in
PowerPoint), select the range, click Copy (or right-click, then Copy).

PowerPoint 2007: open your presentation, find a slide where you want to copy
the range, click the arrow under Paste, click Paste Special, then in “Asâ€
select Picture (Enhanced Metafile), click OK. Copy all the desired ranges
from Excel to PowerPoint. Save your presentation.

Last step: close your Excel workbook without saving, so next time you open
it, the gridlines will still be there.

The cause for this issue – gridlines showing in pasted range as a picture
(EM) in PowerPoint – is SP2. I always could do it so simply – copy and paste
… This evening I have been struggling for hours … SP2 could at least provide
an option whether we want those gridlines in the pasted copy in PowerPoint or
not.

 

[ZK]

Excel 2007: open your workbook, select the worksheets from which you want to
copy a range, click Page Layout, in Sheet Options, under Gridlines, uncheck
the box at view. The gridlines in the selected sheets will disappear. Ungroup
the worksheets.

Go sheet-by-sheet: click far away from the range you want to copy (if not,
the cell with a thick black border will show in your pasted copy in
PowerPoint), select the range, click Copy (or right-click, then Copy).

PowerPoint 2007: open your presentation, find a slide where you want to copy
the range, click the arrow under Paste, click Paste Special, then in “Asâ€
select Picture (Enhanced Metafile), click OK. Copy all the desired ranges
from Excel to PowerPoint. Save your presentation.

Last step: close your Excel workbook without saving, so next time you open
it, the gridlines will still be there.

The cause for this issue – gridlines showing in pasted range as a picture
(EM) in PowerPoint – is SP2. I always could do it so simply – copy and paste
… This evening I have been struggling for hours … SP2 could at least provide
an option whether we want those gridlines in the pasted copy in PowerPoint or
not.