Why can I not link my workbooks in excel

L

Lin4it

I have typed = in Al in workbook 2 and then navigated to the required cell to
link to in workbook 1, then clicked enter. Nothing happens. On my other
machine the same process created a link between the two cells.

I than tried the same thing with a paste link but this did not work either.
Can anybody explain. Is there a setting somewhere that stops workbooks from
linking. I could link between sheets without any problem.
 
A

Ashish Mathur

Hi,

If you see the formula instead of the result, then either of the following
could be the reason:

1. The cell has been formatted as text. To correct for this, press Ctrl+1
on the cell and select General; or
2. You are in Show formulas mode. To see the results instead, pres Ctrl+~

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Linking workbooks 1
Linking workbooks together 1
I can not create an external link between two Excel 2007 workbooks 1
How to create absolue path link to another workbook (Excel 2003) 1
Help - need to consolidate workbooks 3
Links not working in Excel 2007 2
How to create absolute link to cell in another workbook (Excel 2003) 1
Linking Daily Workbooks 1

Top