I have a workbook that does MS Query in Excel by Get External Data>New Database Query. This works fine in a non shared environment eg. Not placing workbook in Share via Tools>ShareWorkbook.
I wish to have this workbook in the Shared mode. Is this possible? At current when I tried, the option to Refresh and to Get External Data is greyed out. I need the end users to be able to see updates and be able to get the queries and then they are able to edit as well. Any help is appreciated!! If not, what are other solutions that I can go??