A
Ang
Hi,
I have created a sheet of pivot tables within a workbook (approximately 20)
which all point to external data (excel spreadsheets)).
I seem to have no problem in using the 'refresh all' button to update the
pivot tables when i open the workbook. However, when anyone else opens this
workbook (which they need to do) and uses the same button they get the error
message:
"cannot open pivot table source file [filename]sheetname"
I can't understand that I (as an administrator) can point to the data and
update ok and another administrator cannot, also a user cannot - who has
direct access to open any of these workbooks and see them.
I have checked macro security and it is set to Medium for all.
I have created a sheet of pivot tables within a workbook (approximately 20)
which all point to external data (excel spreadsheets)).
I seem to have no problem in using the 'refresh all' button to update the
pivot tables when i open the workbook. However, when anyone else opens this
workbook (which they need to do) and uses the same button they get the error
message:
"cannot open pivot table source file [filename]sheetname"
I can't understand that I (as an administrator) can point to the data and
update ok and another administrator cannot, also a user cannot - who has
direct access to open any of these workbooks and see them.
I have checked macro security and it is set to Medium for all.