Hi Guys,
need your help again.
I have lot of lot of Pivot table connected via ODBC going to MS Access. and just this month I already migrated all my tables to SQL server. I created a DSN connected to SQL and change all my pivot to the new connection.
my problem now is if some user will be goin to refresh the pivot, pivot will get errors because i need to declare also the DSN in his/her PC..
is it possible to change my Current DSN Connection to DSN-less Connection?
Hope you guys can help me again.
Thanks.