Geez, I thought this would have helped...

If no, maybe the formula is calculating correctly, but your data isn't what you
think it is (or your formula is pointing to the wrong data????)

<bg

If your data doesn't have any gaps, maybe you could use a dynamic range that
grows/contracts with the data.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic



CJ wrote:

I get a value ... 0

The named ranges are okay ... all the formula calculations work up until mid
October ... Now when I enter the data, it's there on the main page, it's just
not getting picked up on the other pages :(

"Gary''s Student" wrote:

Don't panic. We can always take a single cell and debug it. You are getting
values from the formulae and not errors lik #N/A or #NAME. Next check the
named ranges to make sure they didn't get broken.
--
Gary''s Student


"CJ" wrote:

How do you know that it's not calculating?
I can see the formula and the cell says 0

If it's just the statusbar warning, maybe...
There is no status bar warning

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

ps. What does "cells don't formulate" mean?
The formula isn't working ... the cell shows 0 instead of what it should say

One more way that might "kick start" excel.

Select all the worksheets (click on the leftmost tab and shiftclick on the
rightmost tab),

then edit|replace
what: = (equal sign)
with: =
replace all

Then rightclick on any worksheet and ungroup the sheets.
I just tried all that ... didn't work :(

I'm at my wit's end ... I sure don't want to recreate this whole thing ...
eeeeek



"Dave Peterson" wrote:

How do you know that it's not calculating?

If it's just the statusbar warning, maybe...

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

ps. What does "cells don't formulate" mean?

One more way that might "kick start" excel.

Select all the worksheets (click on the leftmost tab and shiftclick on the
rightmost tab),

then edit|replace
what: = (equal sign)
with: =
replace all

Then rightclick on any worksheet and ungroup the sheets.



CJ wrote:

Our new network administrator tried to keep all company computers from going
on the internet, and in doing so he royally screwed up several spreadsheets
on my computer ... He eventually had to buy me a new computer, but one
spreadsheet still will not calculate ...

I've tried everything I know to get it to work ... All formula cells that
were calculating previous to his blooper still have data in them ... every
cell since then is not working ... and even with the new computer, the cells
don't formulate ...

HELP ...!!!

--

Dave Peterson


--

Dave Peterson