I have a shared workbook which i need to have updating every minute, however
the minimun time allowed under tools\shared workbook\advanced\update changes
every is 5 minutes does any one know of a way that i can change this to
allow automatic updates more frequently.

Many thanks for any help.