Copy pivot table without access to data
New_ly
Posted messages
3
Status
Membre
-
New_ly -
New_ly -
Hello!
I need to create an Excel file that presents a pivot table of my creation
But once I have created the pivot table with the database, I want to ensure that users after me cannot manipulate the data (confidential).
Of course, other users of the file should be able to make modifications without any problems.
How can I do this?
Thank you all!
I need to create an Excel file that presents a pivot table of my creation
But once I have created the pivot table with the database, I want to ensure that users after me cannot manipulate the data (confidential).
Of course, other users of the file should be able to make modifications without any problems.
How can I do this?
Thank you all!
5 réponses
Hello,
You can make yourself a read-only copy of your workbook for the pivot table.
Pivot table options: uncheck 'Data / save source data', delete the data sheet, 'Save as...'
eric
--
By continuously trying, we eventually succeed. So the more it fails, the more chances we have for it to work. (the Shadoks)
In addition to the thank you (yes, it is done!!!), remember to mark it as resolved. Thank you
You can make yourself a read-only copy of your workbook for the pivot table.
Pivot table options: uncheck 'Data / save source data', delete the data sheet, 'Save as...'
eric
--
By continuously trying, we eventually succeed. So the more it fails, the more chances we have for it to work. (the Shadoks)
In addition to the thank you (yes, it is done!!!), remember to mark it as resolved. Thank you
Thank you very much eriiic.
I think I will give this a try!
I will let you know if it worked
Have a great weekend everyone and thank you