aaronmbrown
New Member
- Joined
- Dec 8, 2015
- Messages
- 3
I am connecting Power Pivot to a Pervasive database using a connection string that tests ok and a valid query. The connection works just fine until I save and close Excel. When I re-open and try to refresh the data I receive an error that the connection cannot be made. I check the connection string and it has changed from what I entered. I can re-enter the correct string and the connection test comes back ok. The data still will not refresh using the refresh button on the ribbon. I have to open the table properties and wait for the screen to enter edit mode. Then I can click save and the table will update. I am hoping someone can tell me why the connection string changes when I close Excel.