Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |