Verify a data map before you export the data : Import Export « Collaboration « Microsoft Office Excel 2007 Tutorial






Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer tab, click the Source button
Click the Developer tab, click the Source button
Click the Verify Map for Export link
Click the Verify Map for Export link
Then click OK when it's done.








13.3.Import Export
13.3.1.Export an Excel File to Another Program FormatExport an Excel File to Another Program Format
13.3.2.Import a Text FileImport a Text File
13.3.3.Verify a data map before you export the dataVerify a data map before you export the data
13.3.4.Consolidate Data from Other Worksheets or WorkbooksConsolidate Data from Other Worksheets or Workbooks