On Tuesday, 29 June 2010 at 18:30:43 UTC+10, Ms-Exl-Learner wrote:
On Jun 28, 6:40 pm, Khuli <khuli...@hotmail.com> wrote:
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.
-----------------------
Ms-Exl-Learner
-----------------------
Just closing and opening the files as you suggested worked for me; many thanks!
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)