04-15-2014 08:35 PM
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.