Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.