Excel links problem

  • Thread starter Thread starter Wikegolfa
  • Start date Start date
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?
 
Probably the linked-to cell has become formatted as TEXT. Reformat it for
GENERAL, and all should be well...........

Vaya con Dios,
Chuck, CABGx3
 
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

Formula within filename link 2
alter code to apply to range (links cells w/ row insertions) 1
Excel formula, sum the value cell and if empty cell left blank 0
links 1
Link error #VALUE 5
Links error when insert line/row to source workbook 1
How to create absolue path link to another workbook (Excel 2003) 1
Link error 3

Back
Top