title: Excel removing Pivot Cache unexpectedly
body: <p>I'm working with pivot tables in Excel 2007. I'm retrieving the data from a SQL Server database. In the PivotTable Options dialog box, under the Data tab, the 'Save source data with file' option is checked. However, after I delete the connection to the data source, the Pivot table becomes unworkable and if I try to make any selection I get a message box stating that 'The connection for this PivotTable has been deleted.' Is this an Excel bug or am I doing something wrong?</p>