Formula Referencing Problem
 

We are using Microsoft Office XP and have an Excel file with three
worksheets. A worksheet named 'List' has the raw data. The second
worksheet is named 'Grid', which is the formatted stuff. 96 cells in
'Grid' have formulas that point to cells in 'List'. An example pasted into
this email: =List!A35

The problem: The majority of the cells display the correct values, but
several display the formula. If the formula is deleted and retyped, the
problem is NOT fixed - the formula still displays, not the linked value.

My colleague tells me that this sort problem did not exists with Microsoft
Office 2000.

If anyone has experience with this problem, please let us know.

Thanks,
Bob
Arizona Health Sciences Center
1501 N. Campbell Ave
Tucson, AZ 85724-5030

Formula Referencing Problem
 

I forgot to add that we tried using absolute references too - did not help
"

Formula Referencing Problem
 

Bob,

Check the formatting of the cell (Format menu, Cells item, Number tab) and
ensure that the formatting is NOT text. Change it to General or some
numeric format and re-edit the formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"RGO" wrote in message
...
We are using Microsoft Office XP and have an Excel file with three
worksheets. A worksheet named 'List' has the raw data. The second
worksheet is named 'Grid', which is the formatted stuff. 96 cells in
'Grid' have formulas that point to cells in 'List'. An example pasted into
this email: =List!A35

The problem: The majority of the cells display the correct values, but
several display the formula. If the formula is deleted and retyped, the
problem is NOT fixed - the formula still displays, not the linked value.

My colleague tells me that this sort problem did not exists with Microsoft
Office 2000.

If anyone has experience with this problem, please let us know.

Thanks,
Bob
Arizona Health Sciences Center
1501 N. Campbell Ave
Tucson, AZ 85724-5030

Formula Referencing Problem
 

Chip,
I checked the format of the cell and it was text. I changed the format to
general (tried number too), deleted the formula, reentered it and it works
correctly. Of note: I checked some of the other cells that are working
correctlly and they are formatted as text. Go figure...

Thanks for helping us solve this problem

Bob


"Chip Pearson" wrote in message
...
Bob,

Check the formatting of the cell (Format menu, Cells item, Number tab) and
ensure that the formatting is NOT text. Change it to General or some
numeric format and re-edit the formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"RGO" wrote in message
...
We are using Microsoft Office XP and have an Excel file with three
worksheets. A worksheet named 'List' has the raw data. The second
worksheet is named 'Grid', which is the formatted stuff. 96 cells in
'Grid' have formulas that point to cells in 'List'. An example pasted
into
this email: =List!A35

The problem: The majority of the cells display the correct values, but
several display the formula. If the formula is deleted and retyped, the
problem is NOT fixed - the formula still displays, not the linked value.

My colleague tells me that this sort problem did not exists with
Microsoft
Office 2000.

If anyone has experience with this problem, please let us know.

Thanks,
Bob
Arizona Health Sciences Center
1501 N. Campbell Ave
Tucson, AZ 85724-5030








-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----