Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For some reason externals links are not functioning. If I type "=" and click
on the other workbook to select the cell it does not recognize that I am typing to create a formula between two different workbooks. And, No, I did not click Enter after I typed the "=" sign. Is there something in my Tools, Options that has been disabled? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe the cell is formatted as text - click on the cell and use Format
| Cells | Number (tab) to check how the cell is formatted. Hope this helps. Pete |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So you just see the text of the formula?
If yes, maybe you formatted the cell as text. Format|Cells|Number tab|Choose General Or maybe you're looking at formulas: tools|options|View tab|uncheck formulas Doug wrote: For some reason externals links are not functioning. If I type "=" and click on the other workbook to select the cell it does not recognize that I am typing to create a formula between two different workbooks. And, No, I did not click Enter after I typed the "=" sign. Is there something in my Tools, Options that has been disabled? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Or maybe you started with a leading space???
Doug wrote: For some reason externals links are not functioning. If I type "=" and click on the other workbook to select the cell it does not recognize that I am typing to create a formula between two different workbooks. And, No, I did not click Enter after I typed the "=" sign. Is there something in my Tools, Options that has been disabled? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |