Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Embedded Excel worksheet in Visio - Embedding an Excel workbook and modifying the size of the displayed data

Posted on 2014-01-31
3
Medium Priority
?
2,169 Views
Last Modified: 2014-02-03
1.  I have inserted an excel workbook into my Visio page.
2.  It's too big on the Visio page so I made it smaller by dragging the corner handles.
3.  Looks great on the page.  Everything is readable and my diagram and excel worksheet happily co-co-exist.
4. I double-click to open/edit that workbook.
5.  I make the edits and then click outside the excel worksheet area to return to Visio.
6.  My embedded excel object is now --once again-- too large.  I must re-size it again by dragging the corner handles.

How can I permanently size the embedded Excel object so that I don't have to repeatedly alter the size of the worksheet?
0
Comment
Question by:brothertruffle880
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Steven Harris earned 2000 total points
ID: 39824581
Which version of Visio?

Try the following:

1) Size the object
2) Select the object (click on it once)
3) Developer tab > Shape Design group > Protection
4) Select the applicable protection options:

object protection
0
 

Author Comment

by:brothertruffle880
ID: 39824902
Argh!  Sorry.  Forgot to specify.
I'm using Visio 2013.
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39824962
Above post holds true, I am using 2013 as well.

If you don't have the Developer tab enabled yet:

FileOptionsCustomize Ribbon.  Under the Main Tabs box, enable the Developer tab.

enable developer tab
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question