array functions

Hi.

I'm using an array function in one spreadsheet, but having trouble updating links to the new spreadsheet each period ... I've never successfully updated the links on an array before, I usually end up re-writing the array each time ... does anyone know if is possible to update links for an array?

Suggestions>?

Thanks!

Highlight the cells that you want to update and hit Ctrl+H. Then just type the sheet name the formulas are currently referring to in the first box and the name of the new sheet in the second box and replace all.