linking workbook problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 workbooks and need to link cells. All I should have to do is do a = then open the other book and click on the cell I want to link, but it doesn't work. It won't allow me to higlight a cell or anything... Any ideas? Protected in a odd place
Please email at pkley(at)adtelcom.ne
Thanks!
 
I bet you don't really mean open--maybe swap to the other workbook/worksheet???

A worksheet could be protected in a manner that won't allow selection, but then
you wouldn't be able to select the range normally either. Can you select your
cell on that other worksheet normally?

Maybe post back with a more detailed step-by-step description of what you're
doing.

And maybe this'll make your life easier:

Window|Arrange|Horizontal

So you can see both workbooks/worksheets at the same time. Now just type = and
point to the other worksheet. (This doesn't explain your original problem
though--it just seems easier to me.)
 
Ok, I have both books open and visible. I hit = in the first workbook click on the second workbook and the Titlebar remains Grey, not changing to Blue like it's now the active window. If I double click it, it goes to full screen but the titlebar remains Grey, which I guess means it's not active and therefore won't allow me to select a cell.
I'd post a copy but I don't have a completely unprotected copy right here...
 
If you try it with two brand new workbooks/worksheets, does it work ok?

If you close excel and then reopen in safe mode:

close excel
windows start button|Run
excel /safe

And open both workbooks, does it work ok?

The only way I could duplicate your description is when I protected the
worksheet in code and told xl not to allow any selection of cells:

worksheets("sheet1").EnableSelection = xlNoSelection

===
This didn't match exactly (I could select cells and the title bar changed
colors), but if the worksheet had Freezepanes applied (window|freeze panes),
then (depending on what was visible), I couldn't select off the frozen area.
 
Ok, I opened it in safe mode and still couldn't link by selecting. I'm pretty positive that there isn't any code involved as my manager doesn't know anything about code (neither do I).
 
Ok, another thing I noticed, is that once I press the = and change to the other window, I get a Circle with a Slash (No symbol).
 
Back
Top