I have a pivot table in Excel which gets data pulled from a query with a ODBC connection from an Oracle Database which I set up on a Remote desktop where the Oracle Listener is installed.
The Excel workbook is saved in another Network Drive so that other users can access without having to get into the remote desktop. So when I open the Excel from the Remote desktop and click the refresh all button it refreshes all Pivot Tables with the new Data. Now, other users can´t refresh the Pivot Table from the Network Drive where it is saved because they have no Oracle listnener installed. So I have to let them access the Remote desktop or open and refresh the excel every time they want to have the new data loaded.
It´s simple, I just want to open and refresh the Pivot tables without me or another person having to access the Remote Desktop. Is there any way to do this?
I have seen some posts with some macros that refreshes Pivot Tables like this one: http://www.ozgrid.com/VBA/pivot-table-refresh.htm But it still requires me to open the excel every time I want to get new data.
Thanks in advance
