Eloise T
Active Member
I have two sanitized Excel files attached. One called "Incoming data file" and the other "Outgoing data file."
Both have 7 identical Name Manager names. You may see them by selecting Ctrl+F3.
If I copy and paste a row or rows of data (Columns A thru H) from either Excel file to the other Excel file, 7 windows appear individually as follows:
Clicking [Yes] 7 times works (to satisfy all 7 Name Manager names), but clicking [Yes to All] never works as Yes to All however it functions
exactly the same as clicking [Yes] 7 times.
I do this (copying from one Excel file to the other Excel file) multiple time a day and it sure would be nice for [Yes to All] to work.
Is there an Option that needs to be triggered/switched in the bowels of the the FILE > OPTIONS selection that I'm missing or is this simply an
undocumented Excel bug? Thanks for your assistance in advance.
Both have 7 identical Name Manager names. You may see them by selecting Ctrl+F3.
If I copy and paste a row or rows of data (Columns A thru H) from either Excel file to the other Excel file, 7 windows appear individually as follows:
Clicking [Yes] 7 times works (to satisfy all 7 Name Manager names), but clicking [Yes to All] never works as Yes to All however it functions
exactly the same as clicking [Yes] 7 times.
I do this (copying from one Excel file to the other Excel file) multiple time a day and it sure would be nice for [Yes to All] to work.
Is there an Option that needs to be triggered/switched in the bowels of the the FILE > OPTIONS selection that I'm missing or is this simply an
undocumented Excel bug? Thanks for your assistance in advance.