LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Why won't target cell data changes trigger formula evaluation?

Why wouldn't the formula cells get dynamically calculated when target cell
data is changed? Couldn't find anything about this in help files.

I have been using this worksheet for years and never saw this problem... a
simple 2-week payperiod timesheet ... Fourteen pair of cells in which I enter
start time and end time, and fourteen cells with a formula to compute hours
worked per day (difference between the daily pair). Also weekly and biweekly
totals.

The cells all calculated when I "saved" the file. Also when I
closed/reopened, it still won't evaluate the formula cell(s) when I change a
"data" cell. Only if I hit "save", or individually select each formula
cell, place the cursor in the function box, and press enter.

1) What happened?
2) What can I do to fix it.
3) Is there a command that I can run to "calculate all" functions in a sheet
(or workbook)?
 
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
Formula evaluation Edward New Users to Excel 2 March 31st 09 01:31 PM
Target cell reference moves when target is cut and pasted Illya Teideman Excel Discussion (Misc queries) 5 May 31st 07 11:34 AM
What formula will copy the content & format of the target cell? razorman Excel Discussion (Misc queries) 2 May 11th 07 08:24 PM
I want to hide values if no data in target cell Steve Excel Worksheet Functions 2 November 3rd 06 05:12 PM
formula to lookup value and return value from cell at left of target Tony Strazzeri Excel Worksheet Functions 14 October 3rd 06 08:30 AM


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

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"