don't want someone to open up my graphs to my excel info

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

Guest

How do I lock or prevent my customer from double clicking
on the graph slide and looking at my data table?
 
What I normally do is to insert the graph on a new Sheet and hide other
sheets with a password so no one else can get to the data if they are able
to open the Excel file. If your graph is on the same sheet as your data,
right-click the graph (area towards the outside of the graph) and select
"Location". Change it to a new sheet. Make sure your PowerPoint file still
shows the graph.

Bill Foley
www.pttinc.com
 
Draw menu (bottom left)
Group - Ungroup it

Then it's just objects with no data

Perhaps save a copy for yourself beforehand

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free sample templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com
 
Hello,

PowerPoint does not have the specific capability that you are looking for.
Currently all security and protection features in PowerPoint are applied to
the entire file (not to particular items within a file such as Master
formatting). One of the workarounds for your specific situation
(communicated earlier in this thread) is to send a copy of the presentation
where the Graphs cannot be edited by anyone (even you) because they've been
converted to Office Drawing objects by using the Ungroup command.

If you (or anyone else reading this message) think that PowerPoint should
provide more granular control over who can do what with different parts of
a presentation, don't forget to send your feedback to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also why it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans

Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

This posting is provided "AS IS" with no warranties, and confers no rights.

Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
I see you've gotten several suggestions that are all good ones. Here's
two more that weren't covered.
Copy the chart sheet in Excel to a new workbook (Edit + Move or Copy
sheet) check Copy checkbox and change the pulldown to To New workbook.

Then copy that worksheet into PPT (no datasheet available).
Or In Excel, Hold down the Shift key and choose Edit Copy as Picture
and then paste that into PPT. I personally prefer these methods over
ungrouping since that can sometimes "fracture" the image.

Brian Reilly, PowerPoint MVP
 
I do this kind of thing yet another way:

* Pre-heat oven to 350 degrees
* Display the Excel page in print preview mode
* Use SnaggIt http://www.techsmith.com/ to capture an area shown on the
screen
* Save it as a .jpg or .png file.
* Then, Insert>Picture>From File and resize as necessary.

Serves 4.

Bob Ostwald
 
Great new recipe Bob! Did you know that if you play with SnagIt you can even
make this stretch to feed 6?

--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Thanks. No, haven't tried stretching it. Seems like it would be fewer PPP
(pixels per person) and might be a bit washed out. What's your secret? Grape
Jelly?
 
No, you meatball, its the chili sauce. (By the way, made them yesterday so
that I would get some this time. Love those meatballs!)

--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Kathy,

I'd be very careful here. Bob is the guy who uses a didgeridoo to keep a
bar-b-cue fire lit <vbg>. And I have the photo to prove it!

--
Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Please tell us your ppt version, and get back to us here
 
So do I - And if I can ever get time to write the text that goes with the
fire pictures they will go up on the site!

--
Kathryn Jacobs, Microsoft PPT MVP
If this helped you, please take the time to rate the value of this post:
http://rate.affero.net/jacobskl/
Get PowerPoint answers at http://www.powerpointanswers.com
Cook anything outdoors with http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, and whatever else there is time for
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Hey. That's what I was going for. Otherwise we'd have been gnawing those
bones for the next day's breakfast. And Glen even remarked that I'd found a
note.

Good one, Kathy - matching the meal to Austin's and Glenna's
seven-MVPs-in-a-cave story. For next year, I request the meatballs be
seasoned with apricot jelly and rosemary.

(Folks, this is type of witty badinage and inside jokes you too can
participate in if you attend next year's PPT Live conference.)

Okay, I'm finished. Where the heck is Steve? <G>

Bob
 
Bob,

Found a note? That was what impressed me!

Good one, Kathy - matching the meal to Austin's and Glenna's
seven-MVPs-in-a-cave story. For next year, I request the meatballs be
seasoned with apricot jelly and rosemary.

(Folks, this is type of witty badinage and inside jokes you too can
participate in if you attend next year's PPT Live conference.)
Click to expand...

I'll second that. It was such a hoot, when I look at the photos, I just
wistfully sigh <g>. I scored one of the Mexican milk jugs from Kathy and my
wife absolutely adores it. I also shared a room with Geetesh. Man, I learnt
so much from him about so many things. And I actually met Glenna, and her
accent is soo nice! I am still going through CD's I picked up. And the
desert museum, and Old Tucson town, yada, yada, yada!
 
Back
Top