Dealing with issues related to Xcode's automatic signing can be tricky, especially when it seems to hold onto outdated provisioning profiles. Here's a step-by-step approach to resolve this:

1. Disable Automatic Signing:

   • Open your project in Xcode.
   • Select the project in the Project Navigator.
   • Choose the target for which you want to change the signing settings.
   • Go to the "Signing & Capabilities" tab.
   • Uncheck the "Automatically manage signing" option.
   • After unchecking, you'll be able to manually select your provisioning profile and signing certificate.

2. Clear Existing Provisioning Profiles:

   • On your Mac, navigate to the folder ~/Library/MobileDevice/Provisioning Profiles/.
   • Delete any outdated or unnecessary provisioning profiles. These can sometimes be cached and reused by Xcode.
   • It's often safe to delete all the profiles in this directory, as Xcode will regenerate or you can manually download what you need.

3. Clean the Build Folder:

   • In Xcode, perform a clean operation (Product > Clean Build Folder).
   • This ensures that any cached data from previous builds is removed.

4. Restart Xcode:

   • Close Xcode and then reopen it. This can help in clearing any cached settings.

5. Manually Set Signing:

   • After reopening your project, go back to the "Signing & Capabilities" section for your target.
   • Manually select the correct provisioning profile and signing certificate.

6. Rebuild and Archive:

   • Rebuild your project.
   • If you're preparing for an App Store submission, create a new archive.

7. Validate and Submit:

   • Use the “Validate App” feature in Xcode to check for any issues before submitting to the App Store.

If after these steps you continue to face issues, you might want to consider reviewing your Apple Developer account to ensure that all certificates and provisioning profiles are up to date and correctly configured. Sometimes, issues with signing can stem from expired certificates or profiles that haven't been properly set up in the Apple Developer portal.