Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
I am using Excel 2007 and just a couple days ago my spread sheets were
working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
Automatic calculation may have gotten turned off. You can manully recalc by
pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
That was it! Thank you so much for your help!
"Dave P" wrote: Automatic calculation may have gotten turned off. You can manully recalc by pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
You're welcome.
Thanks for the feedback. "MistyOki" wrote in message ... That was it! Thank you so much for your help! "Dave P" wrote: Automatic calculation may have gotten turned off. You can manully recalc by pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not uodating' problem. Thanks a bunch for F1 and the link to your answer. =)
On Friday, March 13, 2009 2:36 PM MistyOk wrote: I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? On Friday, March 13, 2009 3:42 PM Dave P wrote: Automatic calculation may have gotten turned off. You can manully recalc by pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... On Friday, March 13, 2009 3:49 PM MistyOk wrote: That was it! Thank you so much for your help! "Dave P" wrote: On Friday, March 13, 2009 3:57 PM Dave P wrote: You're welcome. Thanks for the feedback. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not updating' problem. Thanks a bunch for F1 and the link to your answer. =)
On Friday, March 13, 2009 2:36 PM MistyOk wrote: I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? On Friday, March 13, 2009 3:42 PM Dave P wrote: Automatic calculation may have gotten turned off. You can manully recalc by pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... On Friday, March 13, 2009 3:49 PM MistyOk wrote: That was it! Thank you so much for your help! "Dave P" wrote: On Friday, March 13, 2009 3:57 PM Dave P wrote: You're welcome. Thanks for the feedback. On Thursday, October 13, 2011 12:50 AM laser squadron wrote: Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not uodating' problem. Thanks a bunch for F1 and the link to your answer. =) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - not updating formulas
Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not updating' problem. Thanks a bunch for F1 and the link to your answer. =)
On Friday, March 13, 2009 2:36 PM MistyOk wrote: I am using Excel 2007 and just a couple days ago my spread sheets were working fine. All of a sudden I go in to make adjustments for calculating my payroll and the formulas won't update. For example I would copy last payrolls data, and delete the hours information. It doesn't zero out the total column and if I enter new data where the hours were, the formula doesn't recalculate. Now this is in the compatibility mode. If I hit CTRL N formulas still don't work, but if I open it brand new from the quick link in my desktop I can format formulas, but I can't copy and paste. Can someone please tell me what is going on and how to fix it? On Friday, March 13, 2009 3:42 PM Dave P wrote: Automatic calculation may have gotten turned off. You can manully recalc by pressing [F9]. To restore automatic calculation in Excel 2007 go to Orb (Office Button) Excel options Formulas Calculating options select Automatic. Excel will acquire this setting from the first excel file opened in the current session. So if there is a file for which the caluclation method was set to manual and that is the first file opened in a session then the calculation method will remain at manual thouought that session unless changed by the above procedure. Hope this helps. Dave "MistyOki" wrote in message ... On Friday, March 13, 2009 3:49 PM MistyOk wrote: That was it! Thank you so much for your help! "Dave P" wrote: On Friday, March 13, 2009 3:57 PM Dave P wrote: You're welcome. Thanks for the feedback. On Thursday, October 13, 2011 12:50 AM laser squadron wrote: Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not uodating' problem. Thanks a bunch for F1 and the link to your answer. =) On Thursday, October 13, 2011 12:50 AM laser squadron wrote: Thank you Dave P for the posts. I have been using Excel for years and it was only yesterday that I had the 'not updating' problem. Thanks a bunch for F1 and the link to your answer. =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Since updating Office 2003 to 2007 Excel formulas do not work? | Excel Discussion (Misc queries) | |||
Updating Charts in Excel 2007 | Excel Discussion (Misc queries) | |||
automatically updating a column in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel formulas are not automatically updating | Excel Discussion (Misc queries) | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) |