# Which tab does DMT use when XLSX file has multiple tabs **Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5) **Created:** 2016-11-21 15:04 UTC **Views:** 904 **Replies:** 2 **URL:** https://www.epiusers.help/t/which-tab-does-dmt-use-when-xlsx-file-has-multiple-tabs/36371 --- ## Post #1 by @ckrusen I thought DMT always selected the first (Leftmost on the row of tabs). Then I though it selected the active tab. But I have an XLSX file and DMT keeps selecting the last (far right tab). I guess I'll have to start exporting the tab to a new (temp) file and using that for the source data. --- ## Post #2 by @jgiese.wci I always export my working tab to a CSV I’ve had gitchy things happen with XLS files in terms of number formatting and such. A CSV is exactly as it shows nothing left to excels interpretation Joshua Giese Technology Solutions : CTO Direct Phone: 920.593.8299 Office Phone: 920.437.6400 x342 [http://wcibags.com/email/emailFooter4.jpg] --- ## Post #3 by @mhellwig Make sure you save your file before reloading. I have seen DMT select the active tab only randomly but never the last tab. The 100% solution is what Joshua proposed (save as CSV). My personal preference is to save that tab as a new spreadsheet but only when a problem like this persists. You could also try closing DMT and re-launching to see if it finds the first tab of the saved spreadsheet again. --- **Canonical:** https://www.epiusers.help/t/which-tab-does-dmt-use-when-xlsx-file-has-multiple-tabs/36371 **Original content:** https://www.epiusers.help/t/which-tab-does-dmt-use-when-xlsx-file-has-multiple-tabs/36371