If I open a fresh file, Im able to use it. But when I have multiple files open, sometimes the insert data source and refresh get greyed out so i cannot use them. Only way I've been able to get them back to work again is to close out all excel files and then reopen one. Anyone else have these issues and found a fix?
