I have several reports where I copy sheets with lots of graphs and data points to a new workbook. I want to break the links to the graphs, but am a bit worried that I will get errors. I've tried it and for now it works fine. I've seen that Excel remembers the values. Is there a limit to the number of values it can remember.
Say I have a sheet with six graphs, both with two lines and 5 years * 12 months is 60 data points per line. It looks fine to me, but am curious if anybody else has any experience with this.
Say I have a sheet with six graphs, both with two lines and 5 years * 12 months is 60 data points per line. It looks fine to me, but am curious if anybody else has any experience with this.