Formulas do not link to other workbooks


K

Khuli

Usually when linking to another workbook, you start typing the
formula, click in the other workbook, and it adds the file name & cell
reference into the formula.

However, I have a PC at work which has started to behave differently.
When you start to type a formula, and then click into another
workbook, the editing disappears as if you had simply switched to a
different workbook. When you go back to the original workbook, the
cursor is still in the formula bar, but no reference to the other
workbook.

Does anyone have a clue what is going on, and how to cure it?

Thanks!
 
Ad

Advertisements

D

Dave Peterson

Just a guess...

If you have the two workbooks open in different instances of excel, you'll see
the problem.

If you have both workbooks open in the same instance, it should work ok.
 
K

Khuli

Just a guess...

If you have the two workbooks open in different instances of excel, you'll see
the problem.

If you have both workbooks open in the same instance, it should work ok.

Thanks Dave - that was indeed the problem! I had even asked the user
to check that, and was assured that it was the same instance of
Excel! Users..... *rolls eyes*
 
M

Ms-Xl-Learner

Usually when linking to another workbook, you start typing the
formula, click in the other workbook, and it adds the file name & cell
reference into the formula.

However, I have a PC at work which has started to behave differently.
When you start to type a formula, and then click into another
workbook, the editing disappears as if you had simply switched to a
different workbook. When you go back to the original workbook, the
cursor is still in the formula bar, but no reference to the other
workbook.

Does anyone have a clue what is going on, and how to cure it?

Thanks!


Sometime it will happen like this. To get rid of this issue close
both the excel files and open the files one after another and try.
Now it will work fine.
 
Ad

Advertisements

S

selwynshuman

Just a guess...

If you have the two workbooks open in different instances of excel, you'll see
the problem.

If you have both workbooks open in the same instance, it should work ok.

Thanks Dave. I feel stupid for missing that but it was indeed the problem
 

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

Top