A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi Julia Thanks for clarifying, it sounds like Excel is still trying to use cached credentials from your old work account, even though Word has successfully switched to your personal account.
This kind of inconsistency can happen when Office apps store separate login states or credential tokens.
You can try first, sign out of all Office apps (especially Excel and Word) then Quit all Office apps completely (use ⌘ + Q to ensure they’re not running in the background) after that Open Keychain Access, to do this simply go to Applications then Utilities then Keychain Access, in the search bar, type "Office", "Excel", or "Microsoft" then Delete any entries related to your old work account or Office credentials after that Clear Office identity cache to do this simply navigate to ~/Library/Group Containers/UBF8T346G9.Office then delete the folder named "IdentityCache" (if present) after that Restart your Mac then Open Excel and try signing in with your personal account, this should force Excel to forget the old credentials and allow a fresh login.
Let me know how it goes.
Chard