I am using Excel 2007 and using several pivot charts which reference the same table of data. I change the data daily, copy and pasting the data from another source. I have several questions:
Is it possible to change the grouping on the table so that I can view the data differently in different pivot tables? For example, one graph views the data by hour and another by month and another by day. It seems that when I change the grouping for one graph, it changes it on every one. My solution has been to copy and paste in the data into three separate tables for data with each one having different groupings.
Can I somehow create a reference to a date for the pivot tables so that I don’t have to change the dates on every graph drop down? I have about 30 tables and have to change the date each day to the new date and that leaves room for much human error. Another solution would be to have the graphs reference the same data section on the pivot table, is that possible?
When I copy and paste in the data each day, the date ranges change on some of the pivot tables, adding ranges on the bottom and if I don’t notice, it messes up my data. How can I prevent this?
I have the pivot tables linked into a Word document. This may be a Word issue, but every Word document now turns read only after a few saves. It’s very random and they re-imaged my system, rebuild my profile and loaded the OS again, none fixing the problem. I read online but no one had a solution.
Auto Refresh will work on the initial copy and paste into Word from Excel. Any updates to Excel is reflected in Word BUT if I close and open the document, initially the updates will occur upon opening the document but any additional changes are not reflected. It then requires a new copy paste or closing the document and reopening it. How can I get it to auto refresh every time?