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
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
