Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT 16 OLEDB2 connection staying

New Member
Posts: 17
Country: USA

ACT 16 OLEDB2 connection staying

Do I seriously have to reset te OLEDB2 conection in Excel everytime I wan to use a pivot table? I'm trying to do some custom reporting wih pivot tables and I can get the database connected on the first, and the system will refresh with no issues. 

 

But when I save the document and try to open i again, the connection fails. I've ried saving the connection locally and the network and neither seem to work.