Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2248
  • Last Modified:

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

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
brothertruffle880
Asked:
brothertruffle880
  • 2
1 Solution
 
Steven HarrisPresidentCommented:
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
 
brothertruffle880Author Commented:
Argh!  Sorry.  Forgot to specify.
I'm using Visio 2013.
0
 
Steven HarrisPresidentCommented:
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now