Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug
 
Posts: n/a
Default External Links not working

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   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default External Links not working

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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default External Links not working

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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default External Links not working

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External Links and Multiple Instances JMD Excel Discussion (Misc queries) 3 January 3rd 06 09:21 PM
Excel 2003: Temporarily "turning off" links to external files... Birmangirl Excel Discussion (Misc queries) 1 August 19th 05 02:51 PM
External links Andrew Clark Excel Discussion (Misc queries) 1 June 28th 05 04:26 AM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"