LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel links problem

I have a workbook in which the data in one sheet is linked to the data in
another using a formula like ='Sheet1'!A1. The source cell contains text and
I want the same text to appear in the linked cell.

Instead of seeing the text in the destination cell I see instead the
formula. Calculation is set to automatic and pressing F9 makes no difference.

What do I need to do to see the linked text instead of the formula?




 
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
Excel 2007 automatically redirects links - Linking Problem #2!! EMG Links and Linking in Excel 0 August 27th 07 05:58 PM
Problem opening excel file with links Abdul Malik Excel Discussion (Misc queries) 1 October 20th 06 03:52 AM
strange problem with links updates in excel [email protected] Excel Discussion (Misc queries) 1 April 23rd 06 10:59 AM
Problem with updating links in Excel 2003 Mike Gallof Excel Worksheet Functions 1 October 14th 05 05:17 PM
Problem with updating links in Excel 2003 Mike Gallof Excel Worksheet Functions 0 October 14th 05 04:39 PM


All times are GMT +1. The time now is 12:26 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"