baz16
06-16-2016, 05:53 AM
I have created a worksheet with 5 Pivots on 5 different tabs.
The data is pulled from an Access data base stored on a shared drive so others in my team should be able to refresh.
I have also written a basic macro to refresh each pivot,
Sheets("Analysts_Qaulity").PivotTables("PivotTable2").PivotCache.Refresh ).
There are some people who are unable to refresh the tables in my team, myself and 2 others can, but 2 people are unable to. I thought it may have to do with the letter of Drive path they had used to map the shared drive, but I have ensured my query uses the full path name as opposed to the letter eg 's://'.
The people who cannot refresh are being asked to enter a password, and when they just click 'ok', it then comes up with an error message saying "Unrecognised database format,"
Any ideas would be grateful
The data is pulled from an Access data base stored on a shared drive so others in my team should be able to refresh.
I have also written a basic macro to refresh each pivot,
Sheets("Analysts_Qaulity").PivotTables("PivotTable2").PivotCache.Refresh ).
There are some people who are unable to refresh the tables in my team, myself and 2 others can, but 2 people are unable to. I thought it may have to do with the letter of Drive path they had used to map the shared drive, but I have ensured my query uses the full path name as opposed to the letter eg 's://'.
The people who cannot refresh are being asked to enter a password, and when they just click 'ok', it then comes up with an error message saying "Unrecognised database format,"
Any ideas would be grateful