Excel links problem

W

Wikegolfa

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?
 
C

CLR

Probably the linked-to cell has become formatted as TEXT. Reformat it for
GENERAL, and all should be well...........

Vaya con Dios,
Chuck, CABGx3
 
W

Wikegolfa

You are right, the cell was formatted as text and changing the formatting to
general solves the problem.

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

links 1
Automatic Calculation 2
Can I use TEXT command in workbook link? 3
Help! I am having a problem with sort! 2
Vlookups and formats 3
If formula-different numbers entries 2
alter code to apply to range (links cells w/ row insertions) 1
Links 1

Top