If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
calculations quit working
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" 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" 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" 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 |
#22
|
|||
|
|||
calculations quit working
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" 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" 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" 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 |
#23
|
|||
|
|||
calculations quit working
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" 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" 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" 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" 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 |
#24
|
|||
|
|||
calculations quit working
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" 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" 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" 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 |
#25
|
|||
|
|||
calculations quit working
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Working time and days | Nortos | Worksheet Functions | 5 | May 6th, 2005 04:17 PM |
Working time and days | Nortos | General Discussion | 1 | May 6th, 2005 03:47 PM |
Trace Dependents and Precedents not working | Manish | Worksheet Functions | 0 | April 11th, 2005 09:39 PM |
working offline | Felisa | General Discussion | 2 | March 2nd, 2005 01:32 AM |
Hyperlinks quit working in email messages | DLT | General Discussion | 1 | June 5th, 2004 01:01 AM |