| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is it that when I link a cell to one from another worksheet,
The value isn't shown, the formula is??
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is it that when I link a cell to one from another worksheet,
A little more info on this -I'm doing the usual '=' then clicking on the cell
I want the value of, which has worked previously in this spreadsheet. The first time I've tried to link from a new worksheet (8th worksheet) it's showing ='February 08'!E3 instead of the value. "kymposs" wrote: The value isn't shown, the formula is?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is it that when I link a cell to one from another worksheet,
"kymposs" wrote:
Why is it that when I link a cell to one from another worksheet, The value isn't shown, the formula is?? One guess - that particular cell was earlier formatted as TEXT (unknown to you of course). Just re-format as general or number, then either re-do the link or re-activate the link formula by clicking inside the formula bar & pressing ENTER. You need to re-trigger the formula, just re-formatting the cell alone won't activate it. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is it that when I link a cell to one from another workshee
Thanks Max. Just before I read your reply, I looked at the formatting &
realised. 'blonde day' "Max" wrote: "kymposs" wrote: Why is it that when I link a cell to one from another worksheet, The value isn't shown, the formula is?? One guess - that particular cell was earlier formatted as TEXT (unknown to you of course). Just re-format as general or number, then either re-do the link or re-activate the link formula by clicking inside the formula bar & pressing ENTER. You need to re-trigger the formula, just re-formatting the cell alone won't activate it. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is it that when I link a cell to one from another workshee
Ahh, no prob there.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kymposs" wrote in message ... Thanks Max. Just before I read your reply, I looked at the formatting & realised. 'blonde day' |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you link a worksheet name into a cell? | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
| How do I link the worksheet tab to a cell in the worksheet? | Excel Worksheet Functions | |||
| Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Hybrid Mode
