Refresh XML Data in Excel

If you imported XML data, refreshing data from a secure data source in Excel 2007 or Excel 2010 requires editing connection properties.

When you open a saved workbook in Excel, refresh to ensure that the latest data is shown.

  1. Refresh the data:
    Option Description
    Excel 2007 and 2010 logos.  Right-click in the data table and select Refresh or XML > Refresh XML Data.

    The XML Import Error dialog appears.

    Excel 2003 logo.  Right-click in the data table and select Refresh.

    The Connect to ws.webtrends.com dialog appears.

    Continue with step 5.

  2. Excel 2007 and 2010 logos. Select Data > Connections.

    The Workbook Connections dialog box opens.

  3. Excel 2007 and 2010 logos. Select the connection you want and click Properties.

    The Connection Properties dialog box appears.

  4. Excel 2007 and 2010 logos. Click Edit Query.

    The Connect to ws.webtrends.com dialog box appears.

  5. For User name, provide your account and user names in the format account name\user name, for example: my_account\apiuser.