Can see mybook live through windows 7 explorer but not through ms office apps

As long as Windows can see the drive the applications should also see the unit.

Make sure to check your firewall or Internet security settings.

Also, check if the apps will have the same behaviour if the share is mapped on the computer.

Mapping a Personal Cloud drive or WD NAS drive on a Windows PC

http://wdc.custhelp.com/app/answers/detail/a_id/2676