calculations quit working

[CJ]

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 ...!!!

[Gary''s Student]

First try kicking the spreadsheet with CNTRL-ALT-F9
--
Gary''s Student


"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 ...!!!

[CJ]

Hi Gary"s Student ... I had previously tried that ... and tried it again just
now ... no help

This spreadsheet is huge ... The main worksheet consists of rows and columns
of raw data ... then i have another worksheet that totals the raw data by
month/product and then certain yields ... this page reads the rows from the
first sheet by one certain column ... Then there are twelve worksheets of
charts, one for each month ...

I have been using this same basic spreadsheet for eight years and have had
no problems until now ... my second worksheet has calculated no data from the
first sheet since the day our new network admin took over ... (I'm still
wondering how the guy got the job ... LOL)

"Gary''s Student" wrote:

> First try kicking the spreadsheet with CNTRL-ALT-F9
> --
> Gary''s Student
>
>
> "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 ...!!!

[Ron Rosenfeld]

On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!

If you select one of these cells that is not calculating,
what do you see in the CELL?
What do you see in the Formula Bar?

Under Tools/Options/Calculations -- what is selected?

Are these non-calculating cells dependent on macros (either in the cell itself
or in a precedent cell)?

Under Tools/Macros/Security, what is the security level?


--ron

[Dave Peterson]

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

[CJ]

If you select one of these cells that is not calculating,
what do you see in the CELL?
0

What do you see in the Formula Bar?
=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125

Under Tools/Options/Calculations -- what is selected?
Automatic

Are these non-calculating cells dependent on macros (either in the cell
itself
or in a precedent cell)?
No

Under Tools/Macros/Security, what is the security level?
Low

"Ron Rosenfeld" wrote:

> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
>
> If you select one of these cells that is not calculating,
> what do you see in the CELL?
> What do you see in the Formula Bar?
>
> Under Tools/Options/Calculations -- what is selected?
>
> Are these non-calculating cells dependent on macros (either in the cell itself
> or in a precedent cell)?
>
> Under Tools/Macros/Security, what is the security level?
>
>
> --ron
>

[CJ]

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]

If you select that cell with the misbehaving formula, then hit F2 followed by
enter, does the 0 change to something else?

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????)

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

[Dave Peterson]

What's octml?

Maybe:
=SUMIF(Flavor,"="&OctML,TheoryGals)/1.78125
or
=SUMIF(Flavor,OctML,TheoryGals)/1.78125




CJ wrote:
>
> If you select one of these cells that is not calculating,
> what do you see in the CELL?
> 0
>
> What do you see in the Formula Bar?
> =SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
>
> Under Tools/Options/Calculations -- what is selected?
> Automatic
>
> Are these non-calculating cells dependent on macros (either in the cell
> itself
> or in a precedent cell)?
> No
>
> Under Tools/Macros/Security, what is the security level?
> Low
>
> "Ron Rosenfeld" wrote:
>
> > On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> >
> > If you select one of these cells that is not calculating,
> > what do you see in the CELL?
> > What do you see in the Formula Bar?
> >
> > Under Tools/Options/Calculations -- what is selected?
> >
> > Are these non-calculating cells dependent on macros (either in the cell itself
> > or in a precedent cell)?
> >
> > Under Tools/Macros/Security, what is the security level?
> >
> >
> > --ron
> >

--

Dave Peterson

[Gary''s Student]

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
> >

[CJ]

What's octml?
octml means October Mocha Lite ... octml is in the column that the formula
is looking for ... This same formula is in the spreadsheet for every year
since 1998 ... there is a similar formula for every other flavor and every
month ... and there are more things that calculate than just theoretical
gallons ...

This same formula worked in September ...



"Dave Peterson" wrote:

> What's octml?
>
> Maybe:
> =SUMIF(Flavor,"="&OctML,TheoryGals)/1.78125
> or
> =SUMIF(Flavor,OctML,TheoryGals)/1.78125
>
>
>
>
> CJ wrote:
> >
> > If you select one of these cells that is not calculating,
> > what do you see in the CELL?
> > 0
> >
> > What do you see in the Formula Bar?
> > =SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
> >
> > Under Tools/Options/Calculations -- what is selected?
> > Automatic
> >
> > Are these non-calculating cells dependent on macros (either in the cell
> > itself
> > or in a precedent cell)?
> > No
> >
> > Under Tools/Macros/Security, what is the security level?
> > Low
> >
> > "Ron Rosenfeld" wrote:
> >
> > > On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> > >
> > > If you select one of these cells that is not calculating,
> > > what do you see in the CELL?
> > > What do you see in the Formula Bar?
> > >
> > > Under Tools/Options/Calculations -- what is selected?
> > >
> > > Are these non-calculating cells dependent on macros (either in the cell itself
> > > or in a precedent cell)?
> > >
> > > Under Tools/Macros/Security, what is the security level?
> > >
> > >
> > > --ron
> > >
>
> --
>
> Dave Peterson
>

[CJ]

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
> > >

[CJ]

Okay guys ... I've been clicking on everything I can think of ... I just went
to one of the cells that isn't calculating and then went to
Tools/Auditing/Trace Precedents ... Two columns were outlined on the main
page ... but they only go to Row 1000 ... which just happens to be where it
was at when this admin guy messed with my computer

So HOW do I get it to read the whole column ...??

BTW ... thank you all so very much ... your suggestions have been very
helpful ... not to this problem, but in my way of thinking things through

"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]

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

[CJ]

Hi Dave ... I thought the ranges grew with the data ...???

Did you read my general reply to my original query ...??? I've found that
the columns are only being calculated to Row 1000 ... All previous years'
spreadsheets are calculated through the whole column, regardless of how many
rows of data there are ...

This is sooooooooooo confusing

I'll go to Debra Dalgeish's site and start reading my heart out

Thanks again



"Dave Peterson" wrote:

> 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
>

[Ron Rosenfeld]

OK, my guess is that your formula is calculating correctly, but your data is
not what you think it is.

1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
and "TheoryGals" in the list. Click on each of them in turn and tell me what
it says in the "Refers To:" Box.

2. Then check and see if you have any "OctML" entries in the defined range for
"Flavor".

3. If OctML is a text entry in a cell, the "=" is superfluous and should be
eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.

------------------------------------

On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:

>If you select one of these cells that is not calculating,
>what do you see in the CELL?
>0
>
>What do you see in the Formula Bar?
>=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
>
>Under Tools/Options/Calculations -- what is selected?
>Automatic
>
>Are these non-calculating cells dependent on macros (either in the cell
>itself
>or in a precedent cell)?
>No
>
>Under Tools/Macros/Security, what is the security level?
>Low
>
>"Ron Rosenfeld" wrote:
>
>> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
>>
>> If you select one of these cells that is not calculating,
>> what do you see in the CELL?
>> What do you see in the Formula Bar?
>>
>> Under Tools/Options/Calculations -- what is selected?
>>
>> Are these non-calculating cells dependent on macros (either in the cell itself
>> or in a precedent cell)?
>>
>> Under Tools/Macros/Security, what is the security level?
>>
>>
>> --ron
>>

--ron

[CJ]

OMIGOSH ... You are an Angel ...!!!!

It doesn't say quite what you are saying ... but when I clicked on Flavor,
it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
go and change all those to maybe 2000 or so ...

Thank you so very much ...!!!!

All my best ... CJ ~

"Ron Rosenfeld" wrote:

> OK, my guess is that your formula is calculating correctly, but your data is
> not what you think it is.
>
> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
> and "TheoryGals" in the list. Click on each of them in turn and tell me what
> it says in the "Refers To:" Box.
>
> 2. Then check and see if you have any "OctML" entries in the defined range for
> "Flavor".
>
> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
>
> ------------------------------------

[Ron Rosenfeld]

You should be able to make those changes in the dialog box that comes up when
you select Insert/Name/Define.

Glad we were able to run this down.

Best,
--ron



On Sun, 13 Nov 2005 11:55:03 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:

>OMIGOSH ... You are an Angel ...!!!!
>
>It doesn't say quite what you are saying ... but when I clicked on Flavor,
>it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
>go and change all those to maybe 2000 or so ...
>
>Thank you so very much ...!!!!
>
>All my best ... CJ ~
>
>"Ron Rosenfeld" wrote:
>
>> OK, my guess is that your formula is calculating correctly, but your data is
>> not what you think it is.
>>
>> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
>> and "TheoryGals" in the list. Click on each of them in turn and tell me what
>> it says in the "Refers To:" Box.
>>
>> 2. Then check and see if you have any "OctML" entries in the defined range for
>> "Flavor".
>>
>> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
>> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
>>
>> ------------------------------------

--ron

[CJ]

Ack ... I spoke too soon ... I went to all the cells and changed the "refers
to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
my cells still said zero Went back and all "refers to" were back at
1000 ... They won't let me change them

Now what ...???






OMIGOSH ... You are an Angel ...!!!!

It doesn't say quite what you are saying ... but when I clicked on Flavor,
it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
go and change all those to maybe 2000 or so ...

Thank you so very much ...!!!!

All my best ... CJ ~

"Ron Rosenfeld" wrote:

"Ron Rosenfeld" wrote:

> OK, my guess is that your formula is calculating correctly, but your data is
> not what you think it is.
>
> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
> and "TheoryGals" in the list. Click on each of them in turn and tell me what
> it says in the "Refers To:" Box.
>
> 2. Then check and see if you have any "OctML" entries in the defined range for
> "Flavor".
>
> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
>
> ------------------------------------
>
> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
>
> >If you select one of these cells that is not calculating,
> >what do you see in the CELL?
> >0
> >
> >What do you see in the Formula Bar?
> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
> >
> >Under Tools/Options/Calculations -- what is selected?
> >Automatic
> >
> >Are these non-calculating cells dependent on macros (either in the cell
> >itself
> >or in a precedent cell)?
> >No
> >
> >Under Tools/Macros/Security, what is the security level?
> >Low
> >
> >"Ron Rosenfeld" wrote:
> >
> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> >>
> >> If you select one of these cells that is not calculating,
> >> what do you see in the CELL?
> >> What do you see in the Formula Bar?
> >>
> >> Under Tools/Options/Calculations -- what is selected?
> >>
> >> Are these non-calculating cells dependent on macros (either in the cell itself
> >> or in a precedent cell)?
> >>
> >> Under Tools/Macros/Security, what is the security level?
> >>
> >>
> >> --ron
> >>
>
> --ron
>

[Ron Rosenfeld]

What you write does not make sense to me.

Had you done what I suggested, you would have only had to change two references
in the Define Name dialog box.

There should not be 100's of cells there -- just two Names in workbook to be
concerned with, and one "Refers to" for each name.

What, exactly, did you do????

Where were you when you were seeing the "refers to:" line?????



On Sun, 13 Nov 2005 12:30:04 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:

>Ack ... I spoke too soon ... I went to all the cells and changed the "refers
>to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
>my cells still said zero Went back and all "refers to" were back at
>1000 ... They won't let me change them
>
>Now what ...???
>
>
>
>
>
>
>OMIGOSH ... You are an Angel ...!!!!
>
>It doesn't say quite what you are saying ... but when I clicked on Flavor,
>it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
>go and change all those to maybe 2000 or so ...
>
>Thank you so very much ...!!!!
>
>All my best ... CJ ~
>
>"Ron Rosenfeld" wrote:
>
>"Ron Rosenfeld" wrote:
>
>> OK, my guess is that your formula is calculating correctly, but your data is
>> not what you think it is.
>>
>> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
>> and "TheoryGals" in the list. Click on each of them in turn and tell me what
>> it says in the "Refers To:" Box.
>>
>> 2. Then check and see if you have any "OctML" entries in the defined range for
>> "Flavor".
>>
>> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
>> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
>>
>> ------------------------------------
>>
>> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
>>
>> >If you select one of these cells that is not calculating,
>> >what do you see in the CELL?
>> >0
>> >
>> >What do you see in the Formula Bar?
>> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
>> >
>> >Under Tools/Options/Calculations -- what is selected?
>> >Automatic
>> >
>> >Are these non-calculating cells dependent on macros (either in the cell
>> >itself
>> >or in a precedent cell)?
>> >No
>> >
>> >Under Tools/Macros/Security, what is the security level?
>> >Low
>> >
>> >"Ron Rosenfeld" wrote:
>> >
>> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
>> >>
>> >> If you select one of these cells that is not calculating,
>> >> what do you see in the CELL?
>> >> What do you see in the Formula Bar?
>> >>
>> >> Under Tools/Options/Calculations -- what is selected?
>> >>
>> >> Are these non-calculating cells dependent on macros (either in the cell itself
>> >> or in a precedent cell)?
>> >>
>> >> Under Tools/Macros/Security, what is the security level?
>> >>
>> >>
>> >> --ron
>> >>
>>
>> --ron
>>

--ron

[CJ]

Well heck ... I typed a long answer and it seems to have disappeared ...
maybe I clicked the wrong button ... it's been a long day

Anyway ... There are thirteen names in the Name Define area ... I was in a
cell on the worksheet and when I clicked on the Name Define place, I selected
the first name and changed the reference from row 1000 to row 2000 ... then I
clicked on another name and did the same thing, until I did all the names ...
then I clicked on another cell and checked the Name Define place and they all
said 1000 again ... so I thought I had to change each individual cell

Turns out the 2000 isn't sticking and for the life of me I cannot figure out
why ... I even went to one of the named columns and selected it all the way
down to 2000, then clicked on the name range place and selected it from the
drop down list ... but it went right back to 1000

I'm not sure if I'm editing this correctly ...???

"Ron Rosenfeld" wrote:

> What you write does not make sense to me.
>
> Had you done what I suggested, you would have only had to change two references
> in the Define Name dialog box.
>
> There should not be 100's of cells there -- just two Names in workbook to be
> concerned with, and one "Refers to" for each name.
>
> What, exactly, did you do????
>
> Where were you when you were seeing the "refers to:" line?????
>
>
>
> On Sun, 13 Nov 2005 12:30:04 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
>
> >Ack ... I spoke too soon ... I went to all the cells and changed the "refers
> >to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
> >my cells still said zero Went back and all "refers to" were back at
> >1000 ... They won't let me change them
> >
> >Now what ...???
> >
> >
> >
> >
> >
> >
> >OMIGOSH ... You are an Angel ...!!!!
> >
> >It doesn't say quite what you are saying ... but when I clicked on Flavor,
> >it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
> >go and change all those to maybe 2000 or so ...
> >
> >Thank you so very much ...!!!!
> >
> >All my best ... CJ ~
> >
> >"Ron Rosenfeld" wrote:
> >
> >"Ron Rosenfeld" wrote:
> >
> >> OK, my guess is that your formula is calculating correctly, but your data is
> >> not what you think it is.
> >>
> >> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
> >> and "TheoryGals" in the list. Click on each of them in turn and tell me what
> >> it says in the "Refers To:" Box.
> >>
> >> 2. Then check and see if you have any "OctML" entries in the defined range for
> >> "Flavor".
> >>
> >> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
> >> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
> >>
> >> ------------------------------------
> >>
> >> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
> >>
> >> >If you select one of these cells that is not calculating,
> >> >what do you see in the CELL?
> >> >0
> >> >
> >> >What do you see in the Formula Bar?
> >> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
> >> >
> >> >Under Tools/Options/Calculations -- what is selected?
> >> >Automatic
> >> >
> >> >Are these non-calculating cells dependent on macros (either in the cell
> >> >itself
> >> >or in a precedent cell)?
> >> >No
> >> >
> >> >Under Tools/Macros/Security, what is the security level?
> >> >Low
> >> >
> >> >"Ron Rosenfeld" wrote:
> >> >
> >> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> >> >>
> >> >> If you select one of these cells that is not calculating,
> >> >> what do you see in the CELL?
> >> >> What do you see in the Formula Bar?
> >> >>
> >> >> Under Tools/Options/Calculations -- what is selected?
> >> >>
> >> >> Are these non-calculating cells dependent on macros (either in the cell itself
> >> >> or in a precedent cell)?
> >> >>
> >> >> Under Tools/Macros/Security, what is the security level?
> >> >>
> >> >>
> >> >> --ron
> >> >>
> >>
> >> --ron
> >>
>
> --ron
>

[Dave Peterson]

After you change the "refers to" box, make sure you hit the Add button.



CJ wrote:
>
> Well heck ... I typed a long answer and it seems to have disappeared ...
> maybe I clicked the wrong button ... it's been a long day
>
> Anyway ... There are thirteen names in the Name Define area ... I was in a
> cell on the worksheet and when I clicked on the Name Define place, I selected
> the first name and changed the reference from row 1000 to row 2000 ... then I
> clicked on another name and did the same thing, until I did all the names ...
> then I clicked on another cell and checked the Name Define place and they all
> said 1000 again ... so I thought I had to change each individual cell
>
> Turns out the 2000 isn't sticking and for the life of me I cannot figure out
> why ... I even went to one of the named columns and selected it all the way
> down to 2000, then clicked on the name range place and selected it from the
> drop down list ... but it went right back to 1000
>
> I'm not sure if I'm editing this correctly ...???
>
> "Ron Rosenfeld" wrote:
>
> > What you write does not make sense to me.
> >
> > Had you done what I suggested, you would have only had to change two references
> > in the Define Name dialog box.
> >
> > There should not be 100's of cells there -- just two Names in workbook to be
> > concerned with, and one "Refers to" for each name.
> >
> > What, exactly, did you do????
> >
> > Where were you when you were seeing the "refers to:" line?????
> >
> >
> >
> > On Sun, 13 Nov 2005 12:30:04 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
> >
> > >Ack ... I spoke too soon ... I went to all the cells and changed the "refers
> > >to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
> > >my cells still said zero Went back and all "refers to" were back at
> > >1000 ... They won't let me change them
> > >
> > >Now what ...???
> > >
> > >
> > >
> > >
> > >
> > >
> > >OMIGOSH ... You are an Angel ...!!!!
> > >
> > >It doesn't say quite what you are saying ... but when I clicked on Flavor,
> > >it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
> > >go and change all those to maybe 2000 or so ...
> > >
> > >Thank you so very much ...!!!!
> > >
> > >All my best ... CJ ~
> > >
> > >"Ron Rosenfeld" wrote:
> > >
> > >"Ron Rosenfeld" wrote:
> > >
> > >> OK, my guess is that your formula is calculating correctly, but your data is
> > >> not what you think it is.
> > >>
> > >> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
> > >> and "TheoryGals" in the list. Click on each of them in turn and tell me what
> > >> it says in the "Refers To:" Box.
> > >>
> > >> 2. Then check and see if you have any "OctML" entries in the defined range for
> > >> "Flavor".
> > >>
> > >> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
> > >> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
> > >>
> > >> ------------------------------------
> > >>
> > >> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
> > >>
> > >> >If you select one of these cells that is not calculating,
> > >> >what do you see in the CELL?
> > >> >0
> > >> >
> > >> >What do you see in the Formula Bar?
> > >> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
> > >> >
> > >> >Under Tools/Options/Calculations -- what is selected?
> > >> >Automatic
> > >> >
> > >> >Are these non-calculating cells dependent on macros (either in the cell
> > >> >itself
> > >> >or in a precedent cell)?
> > >> >No
> > >> >
> > >> >Under Tools/Macros/Security, what is the security level?
> > >> >Low
> > >> >
> > >> >"Ron Rosenfeld" wrote:
> > >> >
> > >> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> > >> >>
> > >> >> If you select one of these cells that is not calculating,
> > >> >> what do you see in the CELL?
> > >> >> What do you see in the Formula Bar?
> > >> >>
> > >> >> Under Tools/Options/Calculations -- what is selected?
> > >> >>
> > >> >> Are these non-calculating cells dependent on macros (either in the cell itself
> > >> >> or in a precedent cell)?
> > >> >>
> > >> >> Under Tools/Macros/Security, what is the security level?
> > >> >>
> > >> >>
> > >> >> --ron
> > >> >>
> > >>
> > >> --ron
> > >>
> >
> > --ron
> >

--

Dave Peterson

[Ron Rosenfeld]

Hmmm. Did the LAST name you changed "take"? The one you changed just before
you clicked <OK>?

If it did, try clicking the <ADD> button after you make each change. And then
it should "take"

------------------------




On Sun, 13 Nov 2005 15:37:02 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:

>Well heck ... I typed a long answer and it seems to have disappeared ...
>maybe I clicked the wrong button ... it's been a long day
>
>Anyway ... There are thirteen names in the Name Define area ... I was in a
>cell on the worksheet and when I clicked on the Name Define place, I selected
>the first name and changed the reference from row 1000 to row 2000 ... then I
>clicked on another name and did the same thing, until I did all the names ...
>then I clicked on another cell and checked the Name Define place and they all
>said 1000 again ... so I thought I had to change each individual cell
>
>Turns out the 2000 isn't sticking and for the life of me I cannot figure out
>why ... I even went to one of the named columns and selected it all the way
>down to 2000, then clicked on the name range place and selected it from the
>drop down list ... but it went right back to 1000
>
>I'm not sure if I'm editing this correctly ...???
>
>"Ron Rosenfeld" wrote:
>
>> What you write does not make sense to me.
>>
>> Had you done what I suggested, you would have only had to change two references
>> in the Define Name dialog box.
>>
>> There should not be 100's of cells there -- just two Names in workbook to be
>> concerned with, and one "Refers to" for each name.
>>
>> What, exactly, did you do????
>>
>> Where were you when you were seeing the "refers to:" line?????
>>
>>
>>
>> On Sun, 13 Nov 2005 12:30:04 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
>>
>> >Ack ... I spoke too soon ... I went to all the cells and changed the "refers
>> >to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
>> >my cells still said zero Went back and all "refers to" were back at
>> >1000 ... They won't let me change them
>> >
>> >Now what ...???
>> >
>> >
>> >
>> >
>> >
>> >
>> >OMIGOSH ... You are an Angel ...!!!!
>> >
>> >It doesn't say quite what you are saying ... but when I clicked on Flavor,
>> >it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
>> >go and change all those to maybe 2000 or so ...
>> >
>> >Thank you so very much ...!!!!
>> >
>> >All my best ... CJ ~
>> >
>> >"Ron Rosenfeld" wrote:
>> >
>> >"Ron Rosenfeld" wrote:
>> >
>> >> OK, my guess is that your formula is calculating correctly, but your data is
>> >> not what you think it is.
>> >>
>> >> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
>> >> and "TheoryGals" in the list. Click on each of them in turn and tell me what
>> >> it says in the "Refers To:" Box.
>> >>
>> >> 2. Then check and see if you have any "OctML" entries in the defined range for
>> >> "Flavor".
>> >>
>> >> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
>> >> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
>> >>
>> >> ------------------------------------
>> >>
>> >> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
>> >>
>> >> >If you select one of these cells that is not calculating,
>> >> >what do you see in the CELL?
>> >> >0
>> >> >
>> >> >What do you see in the Formula Bar?
>> >> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
>> >> >
>> >> >Under Tools/Options/Calculations -- what is selected?
>> >> >Automatic
>> >> >
>> >> >Are these non-calculating cells dependent on macros (either in the cell
>> >> >itself
>> >> >or in a precedent cell)?
>> >> >No
>> >> >
>> >> >Under Tools/Macros/Security, what is the security level?
>> >> >Low
>> >> >
>> >> >"Ron Rosenfeld" wrote:
>> >> >
>> >> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
>> >> >>
>> >> >> If you select one of these cells that is not calculating,
>> >> >> what do you see in the CELL?
>> >> >> What do you see in the Formula Bar?
>> >> >>
>> >> >> Under Tools/Options/Calculations -- what is selected?
>> >> >>
>> >> >> Are these non-calculating cells dependent on macros (either in the cell itself
>> >> >> or in a precedent cell)?
>> >> >>
>> >> >> Under Tools/Macros/Security, what is the security level?
>> >> >>
>> >> >>
>> >> >> --ron
>> >> >>
>> >>
>> >> --ron
>> >>
>>
>> --ron
>>

--ron

[CJ]

That worked ...!!!

Thank you all for your help today ... I've learned a lot

@}~~~~~~~ CJ

"Dave Peterson" wrote:

> After you change the "refers to" box, make sure you hit the Add button.
>
>
>
> CJ wrote:
> >
> > Well heck ... I typed a long answer and it seems to have disappeared ...
> > maybe I clicked the wrong button ... it's been a long day
> >
> > Anyway ... There are thirteen names in the Name Define area ... I was in a
> > cell on the worksheet and when I clicked on the Name Define place, I selected
> > the first name and changed the reference from row 1000 to row 2000 ... then I
> > clicked on another name and did the same thing, until I did all the names ...
> > then I clicked on another cell and checked the Name Define place and they all
> > said 1000 again ... so I thought I had to change each individual cell
> >
> > Turns out the 2000 isn't sticking and for the life of me I cannot figure out
> > why ... I even went to one of the named columns and selected it all the way
> > down to 2000, then clicked on the name range place and selected it from the
> > drop down list ... but it went right back to 1000
> >
> > I'm not sure if I'm editing this correctly ...???
> >
> > "Ron Rosenfeld" wrote:
> >
> > > What you write does not make sense to me.
> > >
> > > Had you done what I suggested, you would have only had to change two references
> > > in the Define Name dialog box.
> > >
> > > There should not be 100's of cells there -- just two Names in workbook to be
> > > concerned with, and one "Refers to" for each name.
> > >
> > > What, exactly, did you do????
> > >
> > > Where were you when you were seeing the "refers to:" line?????
> > >
> > >
> > >
> > > On Sun, 13 Nov 2005 12:30:04 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
> > >
> > > >Ack ... I spoke too soon ... I went to all the cells and changed the "refers
> > > >to" to go to Row 2000 ... I changed hundreds of cells ... Then went back and
> > > >my cells still said zero Went back and all "refers to" were back at
> > > >1000 ... They won't let me change them
> > > >
> > > >Now what ...???
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >OMIGOSH ... You are an Angel ...!!!!
> > > >
> > > >It doesn't say quite what you are saying ... but when I clicked on Flavor,
> > > >it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
> > > >go and change all those to maybe 2000 or so ...
> > > >
> > > >Thank you so very much ...!!!!
> > > >
> > > >All my best ... CJ ~
> > > >
> > > >"Ron Rosenfeld" wrote:
> > > >
> > > >"Ron Rosenfeld" wrote:
> > > >
> > > >> OK, my guess is that your formula is calculating correctly, but your data is
> > > >> not what you think it is.
> > > >>
> > > >> 1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
> > > >> and "TheoryGals" in the list. Click on each of them in turn and tell me what
> > > >> it says in the "Refers To:" Box.
> > > >>
> > > >> 2. Then check and see if you have any "OctML" entries in the defined range for
> > > >> "Flavor".
> > > >>
> > > >> 3. If OctML is a text entry in a cell, the "=" is superfluous and should be
> > > >> eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.
> > > >>
> > > >> ------------------------------------
> > > >>
> > > >> On Sun, 13 Nov 2005 07:16:06 -0800, "CJ" <CJ@discussions.microsoft.com> wrote:
> > > >>
> > > >> >If you select one of these cells that is not calculating,
> > > >> >what do you see in the CELL?
> > > >> >0
> > > >> >
> > > >> >What do you see in the Formula Bar?
> > > >> >=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
> > > >> >
> > > >> >Under Tools/Options/Calculations -- what is selected?
> > > >> >Automatic
> > > >> >
> > > >> >Are these non-calculating cells dependent on macros (either in the cell
> > > >> >itself
> > > >> >or in a precedent cell)?
> > > >> >No
> > > >> >
> > > >> >Under Tools/Macros/Security, what is the security level?
> > > >> >Low
> > > >> >
> > > >> >"Ron Rosenfeld" wrote:
> > > >> >
> > > >> >> On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" <CJ@discussions.microsoft.com> 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 ...!!!
> > > >> >>
> > > >> >> If you select one of these cells that is not calculating,
> > > >> >> what do you see in the CELL?
> > > >> >> What do you see in the Formula Bar?
> > > >> >>
> > > >> >> Under Tools/Options/Calculations -- what is selected?
> > > >> >>
> > > >> >> Are these non-calculating cells dependent on macros (either in the cell itself
> > > >> >> or in a precedent cell)?
> > > >> >>
> > > >> >> Under Tools/Macros/Security, what is the security level?
> > > >> >>
> > > >> >>
> > > >> >> --ron
> > > >> >>
> > > >>
> > > >> --ron
> > > >>
> > >
> > > --ron
> > >
>
> --
>
> Dave Peterson
>

[Doug T]

Well that little "=" trick helped ME out. I lose my calculations/links when
I move a sheet from one position to another within the workbook. I still
don't know why that happens or how to prevent it but at least I can repair it
now. Thanks!!

"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
>