| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit to number of named ranges before Excel starts messing things up?
Is there a limit to the number of named ranges? I am running into
errors now with my large (large) workbook here, which contains a ton of named ranges just to make things easier for me. For instance, a simple formula such as this: =COUNTA(RBCJobTitle06)-COUNTIF(RBCJobTitle06,"") .... which returns "5" on the sheet in which the named range resides in, returns 17 on another worksheet, and a #REF! error on still another worksheet. Is my workbook messed up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Limit number of character per cell to 26 in excel | Excel Worksheet Functions | |||
| Is there a limit to the number of rows in a excel spread sheet ? | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
