Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In the same workbook, I created links from one worksheet to an other.
For some of the cells (all in the same column), instead of seeing the content of the cell, I see the formula as in the formula bar. For example: In the cell D12 of a worksheet called 'Summary', I want to make a link to the value that appears in the cell D12 of the worksheet called 'Revenues - Retrieve'. The result that appears is this one " ='Revenues - Retrieve'!D12 " , instead of the content of the cell D12. This happens to me sometimes with an other file, which is quite heavy (15Go) with a lot of formulas. In this case, I fix the problem by selecting the cells one after the other, I press F2 then Enter. At times, I fix it by saving the file and when necessary closing and re-opening the file. But none of this seems to be working with the file I'm using at the moment. I closed it, closed Excel, logged off, logged on, re-opened the file, but nothing is changing. Other info: -The file is only 1.34Mo. -I use the option "manual calculation" and press F9 every time I need to refresh a calculation or a link -I use Excel 2003. Have any of you ever accountered a similar problem? Many thanks in advance for your help! Gladys. Last edited by Gladys83 : November 14th 08 at 01:16 PM Reason: additional information |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link malfunction-shows path instead of cell content | Excel Worksheet Functions | |||
Link to cell shows 0 value | Excel Discussion (Misc queries) | |||
External Link Shows Formula Not Info | Excel Worksheet Functions | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) |