View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ricoy-Chicago Ricoy-Chicago is offline
external usenet poster
 
Posts: 2
Default Updating a shared workbook every 30 secs?

Using Excel XP. I am creating a shared workbook, no problem here. However,
the update option in the [Advanced] tab can be set to nothing less than 5
minutes. Is there a way to automatically update every 30 secs or so? or, Is
there some VBA coding I could use to remind the user to save the changes
after they update the workbook?

Thank for any help.