Microsoft KB Archive/923914

= One or more column headings may be unexpectedly named F1, F2, or F3 when you import data from a Excel worksheet in Visio 2007 =

Article ID: 923914

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Visio Professional 2007

-



SYMPTOMS
You import data from a Microsoft Excel worksheet to link to shapes in a Microsoft Office Visio 2007 drawing. When you do this, one or more column headings may be unexpectedly named F1, F2, F3, and so on.

Note These symptoms may occur in the External Data window in the Visio 2007 drawing or in the Data Selector wizard when you perform one of the following actions:
 * You click Select Columns in the Connect to data pane.
 * You click Select Rows in the Connect to data pane.
 * You view the Configure Refresh Unique Identifier pane.



CAUSE
This issue may occur if one of the following conditions is true:
 * The Excel worksheet contains a blank first row.
 * The Excel worksheet contains one or more blank cells in the first row.



WORKAROUND
To work around this issue, use one of the following methods.

Method 1: If the Excel worksheet contains a blank first row
To work around this issue, select the range that you want to use in the Excel worksheet. To do this, follow these steps.

Note Excel must be installed on the computer to complete these steps.
 * 1) Open the drawing in Visio 2007.
 * 2) On the Data menu, click Link Data to Shapes.
 * 3) Click Microsoft Office Excel workbook, and then click Next.
 * 4) Click Browse, select the Excel workbook that contains the data, and then click Open.
 * 5) Click Next.
 * 6) If the workbook contains several worksheets that contain data, select the appropriate worksheet in the What worksheet or range do you want to use box, and then click Select Custom Range.
 * 7) Excel starts automatically. In the Excel worksheet, select the range of data. The range of the data that you select automatically fills the Select Range box of the Import to Visio dialog box. Make sure that the range of data that you select does not include the blank row at the top of the Excel worksheet.
 * 8) Click OK. Excel exits. The range that you selected appends to the worksheet name in the What worksheet or range do you want to use box of the Data Selector wizard.

Method 2: If the Excel worksheet contains one or more blank cells in the first row
To work around this issue, use one of the following procedures:
 * Use Excel to add data to the blank cell.
 * Rename the column headings of the columns that unexpectedly appear as F1, F2, or F3. To rename the column heading, follow these steps:
 * Right-click a column heading in the External Data window, and then click Column Settings.
 * Click the column heading that has the incorrect column name. For example, click F2.
 * Click Rename.
 * Type the correct column name, and then press ENTER.
 * Click OK.

Additional query words: visio2007 visio2k7 visio12 vso2007 vso2k7 vso12 dataselector data selector

Keywords: kbtshoot kbimport kbprb kbexpertisebeginner KB923914

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.