So this is a weird one. I have a workbook connected to a local extract, and I want to connect to the same data held on the server in order to replace the data connection. I do this all the time with no problem.
However on one specific workbook when I go to click on the server version of the data, it just does nothing (blue wheel turns a tiny bit then nothing). BUT:
- Other sever based data sources on the server work fine within that workbook
- The data connection works fine in blank workbooks
Has anyone else had this problem and have any ideas on what to do?