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?

[Steve Rindsberg]

Post by 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.

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/

[JG]

Thanks but yes it is installed.

Post by Steve Rindsberg

Post by 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.

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]

Post by Steve Rindsberg

Post by 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.

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.

[Steve Rindsberg]

Post by Echo S
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.)

What'll they think of next? Correcting the bug where it exports in BW if
you're viewing in BW so it's ... no, wait, that'd make it LESS WYSIWYG and they
already did that. Never mind. ;-)

If it's WYSIWYG they're after, they missed the biggie ... simple Paste from
Excel to PPT leaves the gridlines behind.

But yeah. I think you're right. IAC, I've shot our buddies an email about it.

The other workaround: Paste normally (as an Excel object) gives no gridlines.
Then Ctrl+C, Paste Special as EMF. Still no gridlines.



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

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

[John]

Post by Echo S

Post by Steve Rindsberg

Post by 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.

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.

[Steve Rindsberg]

Post by Echo S
I have exactly the same issue. I don't think I have SP2, I have not installed

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.

Post by Echo S
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.

[shrug] We're volunteers, not MS employees. We work with what we're given. That
often involves watching what goes into the black box, sorting through what comes out
(sometimes nice thick rubber gloves are handy) and guessing at how the former became
the latter.

Post by Echo S
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.

One other option, another bandaid and probably even less useful, but ...

If you paste special as an Excel object rather than as a metafile, you get an
embedded version of your original Excel file. If you doubleclick it, you can use the
Excel toolbar to turn off the grid. This affects only the embedded copy of your
Excel data, not the original file.

Later, you can copy/paste special as EMF to remove the Excel data if you need to.

Hm. Sorta two bandaids to replace the one, isn't it.



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

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

[Echo S]

Post by Echo S

Post by Echo S
I have exactly the same issue. I don't think I have SP2, I have not installed

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.

[Steve Rindsberg]

Post by Echo S

Post by Echo S

Post by Echo S
I have exactly the same issue. I don't think I have SP2, I have not installed

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.

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?


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

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

[Echo S]

Post by Steve Rindsberg

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

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. :-)

[Steve Rindsberg]

John,

I should have thought of this earlier; you might also want to raise
this question in one or more of the Excel newsgroups.

PowerPoint is simply pasting in the EMF data that Excel put on the
clipboard. It's likely a change to Excel that's making it include the
gridlines where before it didn't.

When you do a PasteSpecial in any program, the program shows you what
formats are available on the clipboard, or at least the subset that
it's able to understand.

The app you copied from originally (Excel in this case) determines what
formats it'll put on the clipboard and how the information will be
converted to those formats. It's now including gridlines for some
reason, where before it didn't.


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

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

[ZK]

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

Post by 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?

[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

Post by 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?

[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.
--
ZK

Post by 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?