Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
Recently I had a complete list in Excel 2003 set up to conditionally format
all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
When upgrades are accomplished by the IT team, they do not compensate for
the individual workstation settings, so some of the things that were routine before the update will have to be reset to be routine after the update. It could be that your earlier version had Calculate set to automatic, which would then trigger the conditional format formula as it occurred. Go to ToolsOptionsCalculation and reset your options. "Cassie" wrote in message ... Recently I had a complete list in Excel 2003 set up to conditionally format all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
I actually dont have a Tools Tab, (or if i do, I dont know where to find it)
but following those directions to what I do have I found that there is a Calculation icon in the Formulas menu. However it's already set to automatic and my formatting is still not taking effect immediately except the 25th entry. But still thanks! That got me a little closer. -- Cassie "JLGWhiz" wrote: When upgrades are accomplished by the IT team, they do not compensate for the individual workstation settings, so some of the things that were routine before the update will have to be reset to be routine after the update. It could be that your earlier version had Calculate set to automatic, which would then trigger the conditional format formula as it occurred. Go to ToolsOptionsCalculation and reset your options. "Cassie" wrote in message ... Recently I had a complete list in Excel 2003 set up to conditionally format all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
Is there an "F" key or a shortcut I could use on those pages that may be
effected if I can't set it to automaticaly change? -- Cassie "JLGWhiz" wrote: When upgrades are accomplished by the IT team, they do not compensate for the individual workstation settings, so some of the things that were routine before the update will have to be reset to be routine after the update. It could be that your earlier version had Calculate set to automatic, which would then trigger the conditional format formula as it occurred. Go to ToolsOptionsCalculation and reset your options. "Cassie" wrote in message ... Recently I had a complete list in Excel 2003 set up to conditionally format all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
I do not have xl2007, so my knowledge of the idiosynchrosies of that version
is limited. You need to get someone who has more knowledge to assist you. I think that if you make a new posting and include the conditional format formula that you are using, the file extenstion type of the file (xlxm or xlxs, etc/) and a brief outline of what you have tried, someone might come up with a solution for you. "Cassie" wrote in message ... Is there an "F" key or a shortcut I could use on those pages that may be effected if I can't set it to automaticaly change? -- Cassie "JLGWhiz" wrote: When upgrades are accomplished by the IT team, they do not compensate for the individual workstation settings, so some of the things that were routine before the update will have to be reset to be routine after the update. It could be that your earlier version had Calculate set to automatic, which would then trigger the conditional format formula as it occurred. Go to ToolsOptionsCalculation and reset your options. "Cassie" wrote in message ... Recently I had a complete list in Excel 2003 set up to conditionally format all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto refreshing sheets
Cassie did not say if Autocalc was enabled.
In 2007 Office ButtonExcel OptionsFormulas. The calc mode is set here. Note that the first workbook opened sets the calc mode for all subsequently opened workbooks. Make sure a workbook set to manula calc mode is not opened first. Gord Dibben MS Excel MVP On Fri, 11 Dec 2009 23:21:20 -0500, "JLGWhiz" wrote: I do not have xl2007, so my knowledge of the idiosynchrosies of that version is limited. You need to get someone who has more knowledge to assist you. I think that if you make a new posting and include the conditional format formula that you are using, the file extenstion type of the file (xlxm or xlxs, etc/) and a brief outline of what you have tried, someone might come up with a solution for you. "Cassie" wrote in message ... Is there an "F" key or a shortcut I could use on those pages that may be effected if I can't set it to automaticaly change? -- Cassie "JLGWhiz" wrote: When upgrades are accomplished by the IT team, they do not compensate for the individual workstation settings, so some of the things that were routine before the update will have to be reset to be routine after the update. It could be that your earlier version had Calculate set to automatic, which would then trigger the conditional format formula as it occurred. Go to ToolsOptionsCalculation and reset your options. "Cassie" wrote in message ... Recently I had a complete list in Excel 2003 set up to conditionally format all the cells within a range if there was a total number of 25 non-blank cells. All the names within that range would then automatically change to a red font. Now about 3 weeks ago, we upgraded to 2007... I'm still trying to adjust to the changes! However, these names dont automatically turn red anymore until I go to the next page and back again. What would I have to do to get those changes to appear immediatly when the list hits 25?? -- Have a great day! Sincerely, Cassie . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-refreshing VBA modules/functions/macroes | Excel Programming | |||
Auto refreshing data via VBA | Excel Programming | |||
Tool for auto loading/refreshing/updating/etc... | Excel Programming | |||
Auto Refreshing - values | Excel Programming | |||
Auto Refreshing: data retreival from webpage | Excel Programming |