Pivot Table Saving Problems.....

[parityah]

Hi,

I have a problem with one pivot tabe I have build off a SQL View. Every time I open the workbook, I get an error saying that Excel has to make repairs to this pivot table, the repairs are done successfully, but the table doesn't behave properly until refreshed. Then every time I close the workbook, it makes me do a save as and re-name the worbook. The next time I open it, the same process happens again. Help....

Thanks!