Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Referencing Problem
I forgot to add that we tried using absolute references too - did not help
" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! =----- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having problem with referencing | Excel Worksheet Functions | |||
Referencing Date problem | Excel Discussion (Misc queries) | |||
CountIf formula problem when referencing a column. | Excel Discussion (Misc queries) | |||
Problem w/formula referencing another sheet | Excel Worksheet Functions | |||
Referencing Problem | Excel Discussion (Misc queries) |