What is the digital environment?
Excel version, operating system, storage medium,etc.
What exact message appears on the monitor?
please insert as picture.
What extension does the file always have?
...these are some of the reasons that nobody has been able to propose a solution so far. I can well imagine how annoying it can be when the problem is acute, but please keep in mind that no solution can be proposed without more detailed information.
"Run-time Error 1004" when you make changes to legend entries in a chart in Excel
Thank you for your understanding and patience
I know I don't know anything (Socrates)