User Profile
Pierrick_Guinot
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
How to copy a sheet and keep all its properties
Hello dear all, I made an EXCEL sheet (named Sheet1) in which I fill up a table manually. This table is the data source of several pivot tables and charts, also located in Sheet1. I would like to make several copies of this sheet (one per week), so I just right-clicked on it and made a copy that I called Sheet2. However I noticed that data source of the Sheet2's pivot tables and charts is the table of Sheet1, not the table of Sheet2. It means that filling up the table of Sheet2 won't actualize the pivot tables and charts of Sheet2, but modifying the table of Sheet1 will actualize Sheet2's pivot tables and charts. Is there a way to make a copy of an EXCEL sheet and have all the datasources automatically located in this new sheet ? Thanks a lot in advance. Regards,1.6KViews0likes2CommentsTake in account new lines in a pivot table
Hello dear all, I have made a pivot table with two columns. I use (in a different cell, outside the pivot tabl) the "Average" function to calculate the average value of the results that appear in the second column of my pivot table. The problem is that every time I enter new data in my Excel file, new lines appear in my pivot table, and the "average" function does not take in account these new lines. Do yo guys know if there is a function that allows me to automatically update the range of my "average" function, in order to take in account the new lines that appear in my pivot table ? Thanks a lot in advance.1KViews0likes2Comments
Recent Blog Articles
No content to show