I have a bunch of tables in Access that I export to one Excel spreadsheet. Each table goes to a different worksheet/tab in the same workbook. Each time I do this and then open the Excel workbook all the tabs are automatically chosen/highlighted. So, if I change something in cell A1 of the first tab, every tab's A1 is changed. I have to first remember to "unchoose" the other tabs, which of course I can never remember. Is there a way to export to Excel so all the tabs of the workbook are not automatically chosen/highlighted?
Thanks!