Smart View - embedded task lists in worksheets - anyway to coordinate POV selections

Summary: Smart View - embedded task lists in worksheets - anyway to coordinate POV selections

Content (required): Using smart view in conjunction with PBCS I connect to PBCS and open the task list folder. I then populate excel with tasks from the task list in turn. This works okay, but is there anyway to get the various worksheets POV settings to share changes, or failing this is there any way to set the POV from excel, visual basic?

n.b. I know if you just use the task list without separate worksheets then the standard functionality retains the last change to the POV, where applicable.