A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Link shows formula instead of content of cell



 
 
Thread Tools Display Modes
  #1  
Old November 14th, 2008, 12:05 PM posted to microsoft.public.excel.links
Gladys83
external usenet poster
 
Posts: 2
Default Link shows formula instead of content of cell


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.




--
Gladys83
  #2  
Old November 14th, 2008, 03:30 PM posted to microsoft.public.excel.links
Gary''s Student
external usenet poster
 
Posts: 7,584
Default Link shows formula instead of content of cell

There are two reasons that the formula should display in both the formula bar
and the cell:

1. The shorksheet is is formula display mode. This is toggled by touching
CNTRL-`
This this was the reason then ALL formulas in ALL columns would display this
way.

The cell in he column were formatted to Text prior to the formula being
entered. If this is the reason, fix the formats and re-enter the formulas.
--
Gary''s Student - gsnu2007k


"Gladys83" wrote:


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.




--
Gladys83

  #3  
Old November 14th, 2008, 04:00 PM posted to microsoft.public.excel.links
Gladys83
external usenet poster
 
Posts: 2
Default Link shows formula instead of content of cell


Gladys83;755470 Wrote:
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.


I found the solution: The cells with the formulas that would not
convert were in text format instead of numbers: This is why the links
would not work.

I can't believe it is that simple!




--
Gladys83
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.