Newsfeed
Many worksheets in a single workbook
Suppose you have lots of worksheets in a single Excel workbook and may want to merge data from any of them.
This may not work with all versions of Excel and PowerPoint, but try this:
- Open your workbook in Excel
- Click the tab for the sheet you want to merge from
- Save your file and quit Excel
- Now open your merge template in PowerPoint and do the merge
Merge doesn't request data from any specific worksheet within a workbook; by a lucky coincidence, Excel will give it the data from whatever worksheet is visible when the workbook opens -- and that's the worksheet that was visible when the workbook was last saved.
Handy little trick, that one!
[Previous] [Home] [Next]