Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Visio 2010 : Refreshing Selected Data in Linked Diagrams & Scheduling Data Refresh

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
8/10/2011 6:31:56 PM

1. Refreshing Selected Data in Linked Diagrams


Warning:

Important

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


The procedure in the previous exercise automatically refreshes data from all linked data sources. Many times, this is exactly what you want to do. However, if your Visio diagram is linked to several data sources, there may be times when you want to update the drawing from a subset of the linked repositories.

In this exercise, you will refresh data from some but not all active data sources.


Note:

If they are not already opened, open the HR Process Map with data Visio drawing and the HR Process Data Excel workbook that you worked with in the previous exercise.



Refresh All


  1. In Visio, on the Data tab, in the External Data group, click the Refresh All arrow (below the button), and then click Refresh Data to open the Refresh Data dialog box.

  2. Select one or more data sources.


    Tip:

    There is only one data source in this exercise, but if you’ve linked a drawing to more than one, they will all be listed in this dialog box.


  3. Click the Refresh button, and then click Close.


Note:

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

2. Scheduling Data Refresh


Warning:

Important

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


The preceding two exercises showed you how to manually update the data in your diagram by rereading the data sources. It’s easy to imagine situations in which you would like to have Visio update the data without manual intervention. Each scenario in the following list would be a good candidate for this feature:

  • A network or rack diagram that is used to display near real–time network and server status

  • A call center seating chart that shows which agents are on the phone and which are available

  • A process map that shows up-to-date task status

  • A factory floor plan that displays production statistics, performance threshold warnings, and safety issues

In this exercise, you will set a schedule so Visio will refresh your drawing automatically.


Note:

If they are not already opened, open the HR Process Map with data Visio drawing and the HR Process Data Excel workbook that you worked with in the previous exercise.


  1. In Visio, right-click anywhere in the External Data window, and then click Configure Refresh to open the Configure Refresh dialog box.


    Tip:

    As an alternative to Step 1, you can open the Refresh Data dialog box shown in the previous two sections, select one or more data sources, and then click the Configure button.


  2. In the Configure Refresh dialog box, select the Refresh every nnn minutes check box.

  3. Type 10 or use the spinner control to set the desired refresh interval, and then click OK.

    From this point forward, whenever your drawing is open, the data will refresh automatically at the specified time interval. The data will not refresh when the drawing is closed.


Note:

Save and close the HR Process Map with data Visio drawing and the HR Process Data Excel workbook.

Other -----------------
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Logical & Financial Functions
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Date & Time Functions
- Microsoft PowerPoint 2010 : Editing Comments in a Presentation
- Microsoft PowerPoint 2010 : Adding Comments to a Presentation
- Microsoft Visio 2010 : Creating New Shape Data Fields
- Microsoft Visio 2010 : Refreshing All Data in Linked Diagrams
- 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
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer