Does anyone know if it's possible to break the connection between a pivot table and the data source whilst still maintaining the data in the table? I could try copy/paste special/paste values but thought there migth be a 'proper' way to preserve the data.
Is there any way to break the connection and still be able to manipulate the pivot table? When I remove the data connection, the pivot table no longer functions like a pivot table (i.e. no field list, no filtering, no dragging/dropping of fields, etc.). I thought that the pivot table data (the pivot cache) would still be there after removing the connection and allow full pivot table functionality but that is not the way it is working. The issue here is that I have a workbook with a pivot table that can be refreshed at will after its weekly source data is updated. There is occasion where someone wants to save the data 'as is' so we just save the workbook with a different user-specified name. After this I want to remove the data connection so the user won't accidentily refresh it with new data. But then I would like for them to be able to manipulate the old data with the pivot table.
"I" could, but it is not really me doing it. I have set up several workbooks for several users of varying talent to get fresh data each week. They are the ones that might want to save a week. It would be nice if they could just save to a different name, remove the connection, and go on as if the connection were still there. I still think the pivot cache is there and don't understand why it won't work like a normal pivot table.
I'd like to copy a pivot table into a new sheet for someone but don't want them to be able to drill down into the data. The paste as values works, but is there a way to also maintain the formatting when pasting as values? Thank you.
Is there any way to break the connection and still be able to manipulate the pivot table? When I remove the data connection, the pivot table no longer functions like a pivot table (i.e. no field list, no filtering, no dragging/dropping of fields, etc.). I thought that the pivot table data (the pivot cache) would still be there after removing the connection and allow full pivot table functionality but that is not the way it is working. The issue here is that I have a workbook with a pivot table that can be refreshed at will after its weekly source data is updated. There is occasion where someone wants to save the data 'as is' so we just save the workbook with a different user-specified name. After this I want to remove the data connection so the user won't accidentily refresh it with new data. But then I would like for them to be able to manipulate the old data with the pivot table.
Bookmarks