I have set up a power pivot table linking it to a sequel file.  I have had too many issues with the connection and password and want to change it to a text file.  How do you change from Sequel to text?

Rick

Have a look here:

https://dmoffat.wordpress.com/2013/08/21/how-you-can-change-to-another-connection-type-in-powerpivot/

Hello,

Yes, it is possible to change the data source. You should do the following steps:

1. Click on the QUERY tab;
2. Then, click on the VIEW tab;
3. Now click on Advanced Editor option and it will appear a screen that you can change your data source.

Hugs!

Bruno Destro