Hi in an excel sheet I have a table with a graph that has its selected data as =Workbookname.xlsx!Namedrange When I duplicate this sheet with a second table and graph, the selected data changes to =Sheetname!Cellreferences Id like to be able to stop the workbookname changing to sheetname and stop the named ranges changing to cell references please
Solved by E. B. in 21 mins