Linking to other workbooks

[bakeraj256]

Hi,

I think something may be off with my settings, but I am not sure what.

It is quite standard to create links between workbooks, and generally I do this by inserting an "=" sign in the cell I want data to appear in for Workbook 1, I then open workbook 2 where the desired data is and click on the cell housing the data I want.

I just went to do this, and upon putting the = sign in the cell I want in workbook 1 and clicking in workbook 2 nothing happens except my cursor is now in workbook 2 and the = sign just remains alone in the workbook 1 cell.

If, however, I put an = sign in a cell in workbook on and then click another cell in that sheet or a cell in another worksheet but in the same workbook a proper link is created, so the problem seems to be isolated to links to other workbooks.

Any thoughts? I have never encountered this before and I can't seem to find anything I think would help in the options.

Cheers,

[bakeraj256]

Nevermind, figured out the problem.