In Microsoft Excel 2010, when I paste a range of cells that contain named ranges from one spreadsheet to another where the target also has the same named regions, I get the following dialog, once for each such replicated name range:
A formula or sheet you want to move or copy contains the name 'someNameHere', which already exists on the destination worksheet.
Do you want to use this version of the name?
- To use the name as defined in the destination, click Yes.
- To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box.
The default choice in the dialog is Yes.
I have a repetitive task where by I need to do this copy across about 60 sheets and each such paste has four instances of the dialog.
I always want the
name as defined in the destination.
Is there anyway to configure Excel 2010 to temporarily suppress this dialog and always take the default action of using the
name as defined in the destination without raising the dialog repeatedly?