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

Chapter 40. Retrieving Data from Externa... > Moving Data and Query Definitions to...

Moving Data and Query Definitions to Another Worksheet or Workbook

You may want to use the same external data in more than one workbook, or in more than one worksheet. Also, if you want to preserve any formatting or formulas that you have added to a data range inserted in your worksheet by returning data from Microsoft Query, you need to copy the data to another worksheet before updating the query. Otherwise, the new returned data replaces the old data and all its formatting. If the new result set is larger than the old result set, cells that contain formulas may be overwritten by data in the new result set.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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