Logo
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
EPL Standings
 
 
Windows 7

Microsoft Visio 2010 : Refreshing All Data in Linked Diagrams

8/4/2011 4:12:30 PM

Warning:

Important

The information in this section applies only to the Professional and Premium editions of Visio 2010.


After you have linked data to a Visio drawing, there is a live connection between the two files. In fact, you can make changes to the data source and have those changes appear either manually or automatically in the Visio drawing. This is true whether the drawing is linked to a single data source or to multiple sources.

In this exercise, you will update cells in the Excel data source and see those changes in the Visio shapes.



  1. In the Excel spreadsheet, type Hiring Manager in the Owner cell for process number 104 that currently contains Recruiter.

  2. Type 4/15/2011 in the Start Date cell for process step 104 that currently contains 4/18/2011.

  3. Type In Progress in the Status cell for process step 105 that currently contains Not Started.

    The following graphic highlights the three changes you’ve just made.


    Refresh All


  4. Switch to Visio. Then on the Data tab, in the External Data group, click the Refresh All button (do not click the arrow).


    Tip:

    As an alternative, you can also right-click in the External Data window and click Refresh Data.


    Visio reads data from all linked data sources and shows the result in the Refresh Data dialog box.


    Tip:

    It is not necessary to close the spreadsheet or other data source in order to update the Visio drawing. In fact, in the case of Excel, it is not even necessary to save the changes you’ve made; Visio will read the current data in the linked sheet.

    Occasionally, Visio may display the following dialog box. If you know that the data links in your drawing are correct and safe, click OK. You can prevent future display of this dialog box by selecting the Don’t Show This Message Again check box.


  5. In the Refresh Data dialog box, click Close.

    Compare the data in the External Data window with the spreadsheet in Step 3 and you can see that the changes have been applied to the data in the drawing. For final proof, you should examine one of the shapes whose data you’ve changed.

  6. Open the Shape Data window for the shape titled Interview candidates. The shape correctly reflects the new data in the Excel workbook.


Note:

Save changes to the HR Process Map with data drawing and the HR Process Data workbook but leave them open if you are continuing with the next exercise.



Warning:

Important

The data linking mechanism of Visio is designed for one-way data transfer, that is, for importing data into a Visio diagram. The opposite does not work. In other words, you can refresh the data in a drawing after making changes in a linked data source, but you cannot make changes to data in Visio and then push those changes to the linked data source.

Other -----------------
- Microsoft Visio 2010 : Linking Diagrams to External Data
- Forwarding Events (part 2) - How to Troubleshoot Event Forwarding & How to Configure Event Forwarding in Workgroup Environments
- Forwarding Events (part 1) - How to Configure Event Forwarding in AD DS Domains
- Visual Basic 2010 : Platform Invokes and Interoperability with the COM Architecture - P/Invokes and Unmanaged Code
- Microsoft Visio 2010 : Changing Shape Data Attributes
- Microsoft Visio 2010 : Viewing Shape Data Attributes
- Microsoft Excel 2010 : Building More Powerful Worksheets - Summarizing Data Using Subtotals & Summarizing Data Using Functions
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Lookup and Reference Functions & Using Text Functions
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Solver
- Microsoft Visio 2010 : Editing Shape Data
- Microsoft Visio 2010 : Viewing Shape Data
- Managing Disks : Understanding RAID & Using Disk Maintenance Tools
- Managing Disks : Managing Data Encryption with EFS
- Microsoft Excel 2010 : Building More Powerful Worksheets - Creating Scenarios
- Microsoft Excel 2010 : Building More Powerful Worksheets - Looking at Alternatives with Data Tables
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Data Analysis Tools & Using the Euro Conversion
- Microsoft Visio 2010 : Setting Theme Options
- Microsoft Visio 2010 : Customizing Themes
- Managing Disks : Troubleshooting Disk Management & Managing Data Compression
- Managing Disks : Managing Dynamic Storage - Creating an Extended Volume
 
 
Most view of day
- Windows Phone 8 : Designing for the Phone - Blend Basics (part 1) - Layout
- Microsoft Visio 2010 : Creating and Using Shape Data Fields (part 3) - Saving Sets of Shape Data Fields
- Microsoft Visio 2010 : Using Special Shape Features (part 2) - Control Handles , Hyperlinks, Action Tags
- Accessing and Using Your Network : Learning Some Common Network Tasks
- Adobe Dreamweaver CS5 : Installing Additional Server Behaviors, Creating Custom Server Behaviors
- Integrating BizTalk Server 2010 and Microsoft Dynamics CRM : Communicating from Dynamics CRM to BizTalk Server (part 2) - Writing the Dynamics CRM plugin
- Reporting in Dynamics AX 2009 : Reporting Overview
- Windows Server 2012 : File Services and Storage - Configuring iSCSI storage (part 3) - Configuring iSCSI Target Server - Creating iSCSI virtual disks
- How to Use System Restore, How to Troubleshoot Bluetooth Problems
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Protecting a Worksheet - Apply a Password to a Worksheet
Top 10
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 3) - Creating IPv4 DHCP Scopes
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 2) - Installing DHCP Server and Server Tools
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 1)
- Windows Server 2012 : DHCP,IPv6 and IPAM - Understanding the Components of an Enterprise Network
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 3) - Translating Text with the Mini Translator
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 2) - Translating a Word or Phrase with the Research Pane
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 1) - Setting Options for the Research Task Pane, Searching with the Research Task Pane
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 2) - Ending a Linked Notes Session, Viewing Linked Notes
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 1) - Beginning a Linked Notes Session
- Microsoft OneNote 2010 : Doing Research with Side Notes (part 3) - Moving Side Notes to Your Existing Notes
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro