ExcelBanter - linked cell is displaying formula instead of the data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - linked cell is displaying formula instead of the data (https://www.excelbanter.com/excel-worksheet-functions/45071-linked-cell-displaying-formula-instead-data.html)

silvron

linked cell is displaying formula instead of the data

when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not the
origin cell data.

Anne Troy

Sounds like the cell is formatted as TEXT instead of GENERAL.
************
Anne Troy
www.OfficeArticles.com

"silvron" wrote in message
...
when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not
the
origin cell data.

silvron

that was it, thank you very much...

"Anne Troy" wrote:

Sounds like the cell is formatted as TEXT instead of GENERAL.
************
Anne Troy
www.OfficeArticles.com

"silvron" wrote in message
...
when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not
the
origin cell data.

All times are GMT +1. The time now is 09:33 AM.