View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 1
Default Updating Shared Workbook

OK... I got a shared workbook that 3 different people update every 30 minutes
or so... My question is: I set the actual shared workbook/advanced properties
to automatically update every 5 minutes but every time someone opens the
workbook, they have to manually go into the Tools/SharedWorkbook/Advanced and
change the setting. Is there a way to do this automatically so that anyone
who opens this particular workbook, the Tools/SharedWorkbook/Advanced will
automatically changed to Update every 5 minutes?


--
----------
Chris