| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get rid of the link cell showing the linking formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get rid of the link cell showing the linking formula
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 = "Andrew M" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell showing formula instead of date | Excel Discussion (Misc queries) | |||
| Paste link, showing #### in one cell | Excel Discussion (Misc queries) | |||
| showing and copying a formula in a cell | Excel Worksheet Functions | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
Linear Mode
