Hi
I'm using excel 2010 and I've created a series of pivot tables in a new workbook from another workbook. I want to move these these worksheets to another computer but because they are now in different folders I can't refresh the data without editing the links. However my edit links function is grayed out and the only other way I can see is to edit all of them individually through connections or properties. Is there a way of making the edit links function work or another fast way of updating links? Any help appreciated. Thanks.
Bookmarks