@Kathy1955
It could be so many things... please consider that without specific information it would take too much time for anyone in the forum to put themselves out there :).
If I may recommend, include photos with the message. Inserting the file (without sensitive data) would be even better if this is possible on your part. Include information about your Excel version, operating system and storage medium in your message. In this way, you can come up with a solution proposal much more quickly.
At the same time I add some additional information that might help you further. Since I have to guess, the information is without guarantee :).
If it's a name conflict:
go to the 'Formulas' ribbon and there in the 'Defined names' group to the 'Name manager'.
Or...If it’s a incorrect name entry:
The new name will not be accepted if it
begins with a letter or underscore,
is a cell reference, e.g. A1 or A123 or XFD21, etc.
spaces or characters (\, /, *, [, ], :, ?)
or has the same name as another range in the workbook that you want to copy to.
Additional Informations/links:
Troubleshoot why Excel doesn't save changes
As I said, information that might help you.
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
