Solved

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

Posted on 2014-01-31
3
1,953 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Steven Harris earned 500 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

630 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