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,614 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 500 total points
Comment Utility
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
Comment Utility
Argh!  Sorry.  Forgot to specify.
I'm using Visio 2013.
0
 
LVL 18

Expert Comment

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

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

File > Options > Customize Ribbon.  Under the Main Tabs box, enable the Developer tab.

enable developer tab
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now