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 |
#1
|
|||
|
|||
calculations quit working
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 ...!!! |
#2
|
|||
|
|||
calculations quit working
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 ...!!! |
#3
|
|||
|
|||
calculations quit working
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 ...!!! |
#4
|
|||
|
|||
calculations quit working
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 |
#5
|
|||
|
|||
calculations quit working
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 |
#6
|
|||
|
|||
calculations quit working
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 |
#7
|
|||
|
|||
calculations quit working
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 |
#8
|
|||
|
|||
calculations quit working
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 |
#9
|
|||
|
|||
calculations quit working
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" 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 |
#10
|
|||
|
|||
calculations quit working
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 |
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 |