I'm using Excel with a SQL data connection to generate a Pivot Chart.
The issue I'm having involves the data filters at the top of each column, allowing you to filter the visible values. Upon creation of the worksheet, the selectable values in the data filters is correct. However, if an item is deleted from the database and the Excel data connection data is refreshed, the value that has been removed is still visible as a data filter. (Obviously selecting it results in an empty table since there's no actual data remaining.)
How can I fix this behavior, so a data refresh also updates the list of possible data filter values?
Best Answer
In Excel 2007 and above (maybe 2003 not sure)