Pivot table refreshing data from file in read-only directory?

paulnlondon

New Member
Joined
Jul 20, 2009
Messages
5
Hi,

I wish to have a pivot table in an excel2003 workbook file contained in a directory where a user has read&write permissions picking up data from a source excel2003 workbook file in a directory where the user only has read rights.

This seems fine until the user does a refresh to pick up any changes in the content of the source file. To help them do this I've created a button with the action:

ActiveSheet.PivotTables("tablename").PivotCache.Refresh

Whey they click this there is no error thrown up but the data clears from the table.

Am I trying to do something that isn't achievable? Must the user have permissions to write to the file where the data is coming from? (I couldn't allow that.)

I'd be grateful for comments and suggestions.

Paul
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,123,295
Messages
5,600,789
Members
414,405
Latest member
Zaurb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top