LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
RGO RGO is offline
external usenet poster
 
Posts: 2
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having problem with referencing Doug Excel Worksheet Functions 6 May 8th 10 02:20 PM
Referencing Date problem Raz Excel Discussion (Misc queries) 4 November 18th 09 07:59 PM
CountIf formula problem when referencing a column. Shawn Excel Discussion (Misc queries) 4 October 23rd 09 06:21 PM
Problem w/formula referencing another sheet PatrickP Excel Worksheet Functions 1 January 15th 08 04:42 AM
Referencing Problem Christopher Anderson Excel Discussion (Misc queries) 1 January 29th 05 01:03 AM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"