ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Linking workbooks unpredictable (https://www.excelbanter.com/new-users-excel/232400-linking-workbooks-unpredictable.html)

Johnathan

Linking workbooks unpredictable
 
Have a strange issue. Sometimes I am unable to link two worksheets together.
In some cases when I enter either "+" or "=" in the cell and then click on
the cell in the other workbook that I want to link it does not work. I
thought the issue was related to the workbooks being in different directories
but when i moved them into the same directory it still did not work. Anyone
seen this issue? If so what was the fix.

Dave Peterson

Linking workbooks unpredictable
 
I'm guessing that you have the two workbooks open in different instances of
excel.

Close one of the workbooks (and that instance of excel), then use File|Open in
the remaining instance to open that file once again.

Then try once more.

Johnathan wrote:

Have a strange issue. Sometimes I am unable to link two worksheets together.
In some cases when I enter either "+" or "=" in the cell and then click on
the cell in the other workbook that I want to link it does not work. I
thought the issue was related to the workbooks being in different directories
but when i moved them into the same directory it still did not work. Anyone
seen this issue? If so what was the fix.


--

Dave Peterson


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com