I'm doing a small report with Excel and I'm using Odata from Project Online
I sent the report to a colleague to get his feedback but when he tries to refresh the data, he has to enter his own account and password
Is there a way to store my credentials in the odata connection?
The final idea would be to ask to the IT team to create a generic account which could connect to the data
Thank you for your feedback