Excel Filter: Copying graph from one workbook without retaining references.
October 7, 2008 1:34 PM Subscribe
I have a fairly complex MS Excel Graph "utility" in its own workbook. I would like to add it to other Excel workbooks. When I use the "Move or copy selected sheets..." tool, it copies the graph and the graph data sheet as well, but all the data points in the graph refer back to the original workbook. How can I copy these sheets so that the graph data points refer only to the data in the new workbook?