Hi everyone,
I have a refresh problem with a pivot table.
It is fairly simple in that the data comes from sheet 1 and the pivot tables are on subsequent sheets.
When i set it to update on open, this only works for me.
Sending the sheet to someone, they open it and it does not update.. they see only blank tables.
Turning off update on open, they see the data, until they try and update/refresh the data.
It seems to work perfectly for me on my main computer and on my other non-work computer, but for some reason no-one else.
Macro security is set to low and all plugins have been turned off.
Any tips or pointers would be greatly appreciated.
Thanks,
Jez
I have a refresh problem with a pivot table.
It is fairly simple in that the data comes from sheet 1 and the pivot tables are on subsequent sheets.
When i set it to update on open, this only works for me.
Sending the sheet to someone, they open it and it does not update.. they see only blank tables.
Turning off update on open, they see the data, until they try and update/refresh the data.
It seems to work perfectly for me on my main computer and on my other non-work computer, but for some reason no-one else.
Macro security is set to low and all plugins have been turned off.
Any tips or pointers would be greatly appreciated.
Thanks,
Jez