Analyze in Excel when there are multiple pivot tables that require login verification for each one?

If your credentials for accessing the data source have expired, changed, or are no longer valid, Excel may repeatedly prompt for new credentials every time a refresh is initiated. Sometimes, credentials can become invalid if the data source’s access policy changes

If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!