| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum By Color
Did this function disappear in Excel 2007? I have a worksheet from Excel
2003 using this function. When I open it in Excel 2007, I get the #NAME error. All add-in's have been loaded, so I don't think that's the issue. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum By Color
Don't think thats a 2003 function either.
Someone may have created some VB code in the backgroudn to create this function within the workbook... "Pattylb" wrote: Did this function disappear in Excel 2007? I have a worksheet from Excel 2003 using this function. When I open it in Excel 2007, I get the #NAME error. All add-in's have been loaded, so I don't think that's the issue. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum By Color
I'm not aware of a Sum By Color function in native Excel 2003. I have seen
functions built by other that do this. I'm thinking you'll find something here http://www.cpearson.com/excel/colors.aspx -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Pattylb" wrote: Did this function disappear in Excel 2007? I have a worksheet from Excel 2003 using this function. When I open it in Excel 2007, I get the #NAME error. All add-in's have been loaded, so I don't think that's the issue. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum By Color
You're right. I did use some VBA code. But new Excel should recognize that,
no? THanks for your help. "Barb Reinhardt" wrote: I'm not aware of a Sum By Color function in native Excel 2003. I have seen functions built by other that do this. I'm thinking you'll find something here http://www.cpearson.com/excel/colors.aspx -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Pattylb" wrote: Did this function disappear in Excel 2007? I have a worksheet from Excel 2003 using this function. When I open it in Excel 2007, I get the #NAME error. All add-in's have been loaded, so I don't think that's the issue. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum By Color
I'm so sorry; I'm not thinking. I had to change the security settings in
order for the code to run. Thank again. "Pattylb" wrote: You're right. I did use some VBA code. But new Excel should recognize that, no? THanks for your help. "Barb Reinhardt" wrote: I'm not aware of a Sum By Color function in native Excel 2003. I have seen functions built by other that do this. I'm thinking you'll find something here http://www.cpearson.com/excel/colors.aspx -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Pattylb" wrote: Did this function disappear in Excel 2007? I have a worksheet from Excel 2003 using this function. When I open it in Excel 2007, I get the #NAME error. All add-in's have been loaded, so I don't think that's the issue. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Hybrid Mode
