Hi All,
I usualluy link spreadsheet numbers from one spreadsheet into another. On 2003 version of excel if I double clicked the formula in the cell it would automatically open up and take me to the linked cell in the linked excel file.
Basically this function saved heaps of time finding the relating file and then the referencing cell mannually.
I have now got the 2007 excel version and cannot do this.......any ideas how I can do this?
Help much apprciated!!!
Craig
I usualluy link spreadsheet numbers from one spreadsheet into another. On 2003 version of excel if I double clicked the formula in the cell it would automatically open up and take me to the linked cell in the linked excel file.
Basically this function saved heaps of time finding the relating file and then the referencing cell mannually.
I have now got the 2007 excel version and cannot do this.......any ideas how I can do this?
Help much apprciated!!!
Craig