When we specify the data format MS Excel Worksheets via DDE (*.xls) - we no long get the list to select which worksheet we should pull the data from. Our options are
Entire Spreadsheet or Print Area.... both relating to the first worksheet in the spreadsheet.
I tried to manually enter the specific worksheet name '3Final-Worksheet$'
but that did not work....so how do I get it to look at different worksheets within the spreadsheet.