Excel Recent files not opening after changing User Password
I have a very annoying issue with both Excel and Word files.
Having recently changed my user password on my M3 iMac (two days ago), when I try and open Excel or Word files from their "Recently Open File" viewers I get the following error.
Nothing else has changed on the iMac, the files are held on the local HD and are there, no one else can access the file and I can open all the files direct from Finder in the folder without issue with Excel or Word.
To solve: I have remove the file from Recent Files list in Excel, then opened it again. It reappears in the Recent list but shows the same error when opening. I have opened the file and made a change a save it back, still it won't open. However if I make a brand new file it opens without issue from the recent viewer.
The folder where it is <Documents> is set to Read/Write for my login.
Version of Excel and Word are both up to date and 365 subscriptions
MAC OS is 14.3.1 (23D60)
I have search the forum and web, others have seen similar issues but no one has posted a solution.
Periodic password changing is normal practice so can not see why this will have caused the issue. Looks to be a MAC OS issue as its permissions related. MS help also offered no solutions for a MAC OS user.
Clear suggestions welcome!
Thanks