Linking two excel files

Originally Posted by davesexcel

I am just trying to understand why it changes to a button,
Maybe the cell is Hyperlink??
or
Does it turn to a button all the time or just when you are trying to reference it to another workbook??
did you have buttons on the sheet and delete rows but not the buttons?

Thanks the cell is not a hyperlink and it turns to button only when I am trying to link the cells. Linking to other files works fine.

But I have worked out a way around this problem, but I am still not sure how/why this happens.

you can always forgo the mouse and type:

=Sheet(name)!(cell reference)

replace the () data loseing the ()