How do I get rid of the link cell showing the linking formula

  • Thread starter Thread starter Andrew M
  • Start date Start date
A

Andrew M

Sometimes when I link a cell to another in a different spreadsheet it will
only show the formula not the result.
E.g.

The cell shows "='[PNP stockasat220409(1) Working V2 New SKU
identified.xlsx]Stock List - Supplier Informati'!A4"
This is seen, I owuld have expected the value in the cell reference to show.
This is only happening sometimes.
Any ideas on how to correct?
Andrew
 
This happens when the cell containing the formula is formatted as TEXT.
Change the formula to GENERAL.

Also make sure that the first character in the cell is = and you have not
inadvertently entered ' before =
 

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

Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) 4
automatically show cell references of formulas 2
Why does link show as a formula 7
how do i show the calculated value in a cell rather than formula 3
Cell only shows formula entered 2
How do I get rid of duplicate rows? 5
why do some cells show up as XXXX's on a shared drive 2
How do I attach a number to a cell with text to use in a formula? 1

Back
Top