PPT 2007 - Bringing Over Excel 2007 Charts

[Alex Zimmerhaven]

Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation today. My
users saw that when you created a chart in PowerPoint 2007, it used the Excel
2007 charting engine - which means you could see the data in an Excel 2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint 2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003 charting
engine. I'm not quite seeting this option in PowerPoint 2007. However, that
really doesn't address their question as much - since they are trying to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to need to
continue to bring charts over to PowerPoint 2007 the way they always have?
Or is there some newfangled shortuct/method since we now have the "Excel 2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are lifesavers!

Thanks,
Alex Zimmerhaven

 

[Echo S]

Have them copy the chart in Excel and paste onto the PPT slide. Click the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the entire
workbook into the presentation. This caught users off guard -- they didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and choose
"Excel Chart (entire workbook)" to embed the whole thing.

 

[Alex Zimmerhaven]

Echo,

Thanks millions for your assistance with this issue. I really appreciate
it! I spent a lot of time on your website last year - so I'm honored to be
getting an answer from you. : ) (I've recommended your site to many)

I see what you are saying - thanks for enlightening on that point. I guess
what's confusing is that my users don't want to embed,link or bring an image
over to "PowerPoint 2007" from a chart in "Excel 2007". They want it to
appear as if they created the chart in "PowerPoint 2007" (even thought it was
really created in "Excel 2007").

Sometimes when you embed a chart in PowerPoint 2007 it looks strange.
Obviously the linking presents the problem of having to have the excel file
with you anywhere you go. And then there's problem of not being to change
the image you bring over.

So, do you see any way to somehow to push the "Excel 2007" chart to
"PowerPoint 2007" in such a way so that it appears you actually created the
chart in "PowerPoint 2007"? When you create a chart in "PowerPoint 2007" it
gives you the excel sheet showing you the data. If there were a way to
somehow push the "Excel 2007" data and "Excel 2007" chart type over to that
spreadsheet that shows up in "PowerPoint 2007", that would be great. But I
don't think it's possible.

Any thoughts? Again, thank you for all of your help - you and all of the
volunteers on this board are just so helpful.

Thanks!
Alex Zimmerhaven

Have them copy the chart in Excel and paste onto the PPT slide. Click the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the entire
workbook into the presentation. This caught users off guard -- they didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and choose
"Excel Chart (entire workbook)" to embed the whole thing.

--
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

Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation today.
My
users saw that when you created a chart in PowerPoint 2007, it used the
Excel
2007 charting engine - which means you could see the data in an Excel 2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint 2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003
charting
engine. I'm not quite seeting this option in PowerPoint 2007. However,
that
really doesn't address their question as much - since they are trying to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the
presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to need
to
continue to bring charts over to PowerPoint 2007 the way they always have?
Or is there some newfangled shortuct/method since we now have the "Excel
2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are lifesavers!

Thanks,
Alex Zimmerhaven

 

[Echo S]

Hi, Alex,

What a nice thing to say. Thank you.

Unfortunately, I don't have any magic bullets for you.

In my opinion, the difference between creating a chart in PPT 2007 and
pasting one in from Excel 2007 (choosing the "entire workbook" paste option)
isn't all that different. In fact, I think it might be identical.

When I right-click either type of chart and choose Edit Data, they both open
the Excel workbook, and it says "Chart in Microsoft Office PowerPoint -
Microsoft Excel." I can't really tell the difference.

If I were to paste the Excel chart and NOT choose "embed entire workbook,"
then I could see more differences.

Sometimes when you embed a chart in PowerPoint 2007 it looks strange.

Could you clarify this more? There are a gazillion ways to get an Excel
chart into PPT, sure, but in PPT 2007 pasting and choosing "entire workbook"
is really pretty much identical to using the Chart button on PPT's Insert
tab of the Ribbon. It didn't used to be that way, of course, so maybe your
users are still thinking about how it worked in 2003?

When you create a chart in "PowerPoint 2007" it
gives you the excel sheet showing you the data.

It does that when you paste an Excel chart into PPT 2007, too. If you just
paste the chart in and don't mess with the paste options, then you get a
linked chart. When you right-click and choose Edit Data, it opens the
spreadsheet and the spreadsheet says "Filename.xlsx - Microsoft Excel" at
the top of the Window.

But, as I explained earlier, if you paste and change the paste option to
"entire workbook," then when you right-click and choose Edit Data, it opens
the spreadsheet and it says "Chart in MS Office PPT - Microsoft Excel" at
the top of the Window. That's exactly what it says if you used Insert |
Chart in PPT to create the chart.

What I'm saying is that it should appear as though the chart was created in
PPT. Personally, I'm not sure how you'd tell the difference.

So I'm struggling to understand what exactly it is your users are after.

There may be a way to import data from an Excel workbook into another
workboook, but I'm not sure off the top of my head how to do that most
efficiently. Hopefully one of the Excel MVPs will pop in with ideas.

--
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

Echo,

Thanks millions for your assistance with this issue. I really appreciate
it! I spent a lot of time on your website last year - so I'm honored to
be
getting an answer from you. : ) (I've recommended your site to many)

I see what you are saying - thanks for enlightening on that point. I
guess
what's confusing is that my users don't want to embed,link or bring an
image
over to "PowerPoint 2007" from a chart in "Excel 2007". They want it to
appear as if they created the chart in "PowerPoint 2007" (even thought it
was
really created in "Excel 2007").

Sometimes when you embed a chart in PowerPoint 2007 it looks strange.
Obviously the linking presents the problem of having to have the excel
file
with you anywhere you go. And then there's problem of not being to change
the image you bring over.

So, do you see any way to somehow to push the "Excel 2007" chart to
"PowerPoint 2007" in such a way so that it appears you actually created
the
chart in "PowerPoint 2007"? When you create a chart in "PowerPoint 2007"
it
gives you the excel sheet showing you the data. If there were a way to
somehow push the "Excel 2007" data and "Excel 2007" chart type over to
that
spreadsheet that shows up in "PowerPoint 2007", that would be great. But
I
don't think it's possible.

Any thoughts? Again, thank you for all of your help - you and all of the
volunteers on this board are just so helpful.

Thanks!
Alex Zimmerhaven

Have them copy the chart in Excel and paste onto the PPT slide. Click the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the
entire
workbook into the presentation. This caught users off guard -- they
didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information
and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and
choose
"Excel Chart (entire workbook)" to embed the whole thing.

--
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

Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation today.
My
users saw that when you created a chart in PowerPoint 2007, it used the
Excel
2007 charting engine - which means you could see the data in an Excel
2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they
could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint
2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back
in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003
charting
engine. I'm not quite seeting this option in PowerPoint 2007.
However,
that
really doesn't address their question as much - since they are trying
to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the
presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to
need
to
continue to bring charts over to PowerPoint 2007 the way they always
have?
Or is there some newfangled shortuct/method since we now have the
"Excel
2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are
lifesavers!

Thanks,
Alex Zimmerhaven

 

[Bob]

Hello!

Is there some way to programatically (VBA) edit the Excel Chart?

I'm reading threads saying that this i no longer possible with 2007? (no OLE
object)
Incredible, if true!

But, I have an idea:
Is it possible to emulate the button pression?
Something like
Application.CommandBars.ExecuteMso ("Edit Data")
(This doesn'twork, I think...)

Afterwards, It may be possible to "guess" which data/chart is the original
and continue editing in Excel?

What would be the right commandbar? ("Edit Data") is a "right clicking"
pane.


Many thanks,

Bob

 

[Bob]

Hello!

Is there some way to programatically (VBA) edit the Excel Chart?

I'm reading threads saying that this i no longer possible with 2007? (no OLE
object)
Incredible, if true!

But, I have an idea:
Is it possible to emulate the button pression?
Something like
Application.CommandBars.ExecuteMso ("Edit Data")
(This doesn'twork, I think...)

Afterwards, It may be possible to "guess" which data/chart is the original
and continue editing in Excel?

What would be the right commandbar? ("Edit Data") is a "right clicking"
pane.


Many thanks,

Bob

 

[Bob]

SP2: Haleluja!

Some way to be a beta tester? To adapt all existing 2003 code to 2007 SP2?

Bob

 

[Boris]

Hi Echo,
Any idea why this option does not appear whet you paste the chart using
paste speceial - microsoft office graphic object? Indeed, if you use the
paste special, the behaviour seems to ignore whetehr you select the "paste
link" or not!...
Best wishes, Boris.

Have them copy the chart in Excel and paste onto the PPT slide. Click the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the entire
workbook into the presentation. This caught users off guard -- they didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and choose
"Excel Chart (entire workbook)" to embed the whole thing.

--
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

Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation today.
My
users saw that when you created a chart in PowerPoint 2007, it used the
Excel
2007 charting engine - which means you could see the data in an Excel 2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint 2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003
charting
engine. I'm not quite seeting this option in PowerPoint 2007. However,
that
really doesn't address their question as much - since they are trying to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the
presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to need
to
continue to bring charts over to PowerPoint 2007 the way they always have?
Or is there some newfangled shortuct/method since we now have the "Excel
2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are lifesavers!

Thanks,
Alex Zimmerhaven

 

[Echo S]

Hm. It should be the first option. Usually the first option in Paste Special
is the same as the default Paste (regular Paste) behavior.

Oh, wait, I see. It comes up as a "graphic object." Duh -- just what you
said!

Wow, I have no idea. I think Steve and I talked about this awhile back, but
I don't remember this being an issue. Hm. Lemme noodle on this a bit.

--
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

Hi Echo,
Any idea why this option does not appear whet you paste the chart using
paste speceial - microsoft office graphic object? Indeed, if you use the
paste special, the behaviour seems to ignore whetehr you select the "paste
link" or not!...
Best wishes, Boris.

Have them copy the chart in Excel and paste onto the PPT slide. Click the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the
entire
workbook into the presentation. This caught users off guard -- they
didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information
and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and
choose
"Excel Chart (entire workbook)" to embed the whole thing.

--
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

Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation today.
My
users saw that when you created a chart in PowerPoint 2007, it used the
Excel
2007 charting engine - which means you could see the data in an Excel
2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they
could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint
2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back
in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003
charting
engine. I'm not quite seeting this option in PowerPoint 2007.
However,
that
really doesn't address their question as much - since they are trying
to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the
presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to
need
to
continue to bring charts over to PowerPoint 2007 the way they always
have?
Or is there some newfangled shortuct/method since we now have the
"Excel
2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are
lifesavers!

Thanks,
Alex Zimmerhaven

 

[Echo S]

That is so bizarre. I've never had an issue with this, but once Boris posted
about it, now I do!

I don't actually paste special charts all that often, though, so it may just
be that I've not had many chances to run across it.

You know, I also thought maybe it had to do with saving the Excel file
first...but no, that doesn't seem to make a difference.

I say we just blame Boris.

--
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

Something like this happens to me routinely in Office 2007.
The first and sometimes second time I select content in Excel and then go
to
Paste Special in PPT, the option I want isn't availalble.

Go back to Excel and repeat the copy a time or to and
voi_by_some_mysterious_process_la ... there it is.

I've never been able to pin down the cause or the difference in what I do
that
makes it work sometimes and not others.

So do we chalk it up to magic or "sufficiently advanced technology"? ;-)

Hi Echo,
Any idea why this option does not appear whet you paste the chart using
paste speceial - microsoft office graphic object? Indeed, if you use the
paste special, the behaviour seems to ignore whetehr you select the
"paste
link" or not!...
Best wishes, Boris.

Have them copy the chart in Excel and paste onto the PPT slide. Click
the
Paste Options button that appears and choose "Excel Chart (entire
workbook)." This will embed the workbook into their presentation.

In fact, the default behavior in PPT 2003 and prior was to paste the
entire
workbook into the presentation. This caught users off guard -- they
didn't
expect all the rest of the data in their workbooks to end up in their
presentation files, so people inadvertently sent out salary information
and
stuff like that -- they just didn't realize it was there.

So MS changed the default behavior in 2007. Now when you paste an Excel
chart into PPT, the default behavior is to insert a chart object that's
linked to the Excel workbook. If you send the file to someone who
doesn't
have access to the workbook, they get just an image of the chart on the
slide. That's why your users must hit that Paste Options button and
choose
"Excel Chart (entire workbook)" to embed the whole thing.

--
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


message Hi everyone,

Thanks in advance for all of the great work you guys do! Thank you
for
taking time to answer these questions!

Well, here's my issue. I was giving an Office 2007 presentation
today.
My
users saw that when you created a chart in PowerPoint 2007, it used
the
Excel
2007 charting engine - which means you could see the data in an Excel
2007
spreadsheet. (instead of that old PowerPoint 2003 charting engine)

Well, they got excited and thought that there might be someway they
could
bring the chart and data over from Excel 2007 - in such a way, that
PowerPoint 2007 would see the chart and data as "it's own".

So - instead of Pasting in the chart from Excel 2007 as:
1) Excel Object
2) Static Image (JPG, etc.)
3) Linked object

They wanted to circumvent all of that and somehow use the PowerPoint
2007
Excel spreadsheet engine and put the chart and data over to that - so
PowerPoint 2007 would see the chart as "it's own".

I'm not sure if all of this makes sense or not. I do recall - back
in
"PowerPoint 2003" you could "import" data into the PowerPoint 2003
charting
engine. I'm not quite seeting this option in PowerPoint 2007.
However,
that
really doesn't address their question as much - since they are trying
to
bring the chart and the data over.

The problem they are having is that the managers are creating "Links"
between Excel 2003 and PowerPoint 2003, and then just taking the
presentation
with them and not the "links".

So - I guess the short answer to all of this - are my users going to
need
to
continue to bring charts over to PowerPoint 2007 the way they always
have?
Or is there some newfangled shortuct/method since we now have the
"Excel
2007
charting engine" in PowerPoint 2007.

Thank you again to all of the MVP's out there. You guys are
lifesavers!

Thanks,
Alex Zimmerhaven

 

[Boris]

Hi Steve and Echo,
I must admit, I had simply given up trying to paste charts from Excel other
than as a link. It never dawned on me that the option would only appear
(reliably, at least) when you select paste, not paste special... And I must
admit, I have never had the option appear (yet) when I have selected paste
special (but I will play with the idea of just trying it a few times)... For
now, I am just pleased that I know I can do what I had wanted using the
simple humble (in previous versions of office at least) paste command...
Thanks again for all your help.
Best wishes, Boris.

 

[Echo S]

I sure wish everyone (including me!) were so easily pleased, Boris. Thanks
for bringing this up -- maybe eventually MS will fix it....