I have an Excel document that is linked to my SharePoint 2010 list. Recently my list climbed over the 5000 limit so I had to add some filtering to my view. This negatively impacted my Excel document because the data got filtered there as well. In Excel I have a report that is built on the data so I need the entire content of the list.
I know that Access links to the content of the list and ignores the view. Is there a way that Excel can do the same thing?
I tried using the Query List Data with Excel with no success. The only thing that I have gotten to work is to have a second view without filters that I link to but I feel that is not the best way to go about this.