• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Importing Business Data into... > Working with External Data Ranges

Working with External Data Ranges

When you have imported data into a worksheet as the previous section described, you have more than just the data set itself. A new range name is automatically defined, and refers to the range of cells defined by the fields and records that were returned. That data range has properties that you can manipulate. You can access the properties by clicking the Properties button on the Import Data dialog box (see Figure 18.9).

But it's usually best to have a look at the data before you start changing the ranges properties. You can modify the properties after the data has been written to the worksheet. Just right-click any cell in the external data range and choose Data Range Properties from the shortcut menu. When you do so, the External Data Range Properties dialog box appears, as shown in Figure 18.15.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint