Hi
I am trying to change the datasource for data in an excel spreadsheet (Excel 2010) linked to a SQL view. I want to change it to another view on the same server.
I normally would change the query but for some reason when I go to data, connection properties, definition the edit query is greyed out. I tried to link it to another data connection but it does nothing.
Any ideas why the edit query is greyed out Or another way so I can give it another connection and make it refresh the data using the new view.
Thansk
I am trying to change the datasource for data in an excel spreadsheet (Excel 2010) linked to a SQL view. I want to change it to another view on the same server.
I normally would change the query but for some reason when I go to data, connection properties, definition the edit query is greyed out. I tried to link it to another data connection but it does nothing.
Any ideas why the edit query is greyed out Or another way so I can give it another connection and make it refresh the data using the new view.
Thansk