Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
noclue
 
Posts: n/a
Default Show info in linked cells in dif workbks?

I am linking cells in different workbooks together. All that I am getting the
destination cell is the formula or address. How do I get the actual info to
be displayed?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Make sure the destination cells are not text formatted. If they are not text
formatted,
select all destination cells, do editreplace and replace = with = (replace
equal sign with equal sign)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"noclue" wrote in message
...
I am linking cells in different workbooks together. All that I am getting
the
destination cell is the formula or address. How do I get the actual info
to
be displayed?



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
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
Two spreadsheets linked - moving cells Adam Excel Discussion (Misc queries) 1 January 4th 05 12:59 PM
paste info into merged cells Marc Setting up and Configuration of Excel 0 December 6th 04 09:09 PM
Sorting mixed up linked cells in a workbook? Destiny Excel Worksheet Functions 2 November 20th 04 03:17 AM
How to stop #REF! on linked cells in complex spreadsheets Formann Excel Worksheet Functions 0 November 18th 04 12:34 PM


All times are GMT +1. The time now is 04:01 AM.

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

About Us

"It's about Microsoft Excel"