When building views in your worksheets, it is important to use one data source per worksheet to prevent blending.Repeat steps 3 through 5 to add as many data sources & worksheets as desired.If you like, you can navigate back to the most recently created Worksheet to see fields from the new data source available for use. Connect to a new data source (and if necessary, drag the tables into the (empty) data relationship window).Using the top menu bar, select Data > New Data Source. (This can also be done with Ctrl+D).This Worksheet will utilize data from your first data source. See Connect to Your Data for more information. Connect to the primary data source as usual.QuestionHow to have multiple data sources in the same workbook, but not join or blend their data.
0 kommentar(er)
