AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 197
Today I got ambushed in a planning meeting, regarding my use of Named cells in large worksheets that are updated yearly.
In essence, we have about 50 worksheets with formulas related, for example, to FX rates. I have a worksheet called, "Input" that creates all sorts of single named cells for FX. In the named cells, I put the current FX for five countries, and name them as follows.
EURO
GBP
CAD
AUD
NZD
Then my formulas use the different names, where appropriate.
The thing is, we don't change anything else. So the formulas could as easily be linked to those cells with $ $ (e.g., $A$1), forever.
I have been told that I can no longer use named cells, because it "confuses" others looking at my files. When I objected -- as I sometimes look at the cells and "EURO" is easy to see that it is the FX I want, versus $A$1 -- they added, that named cells slow down performance in general and makes the file huge. They named other things -- files crashing, getting corrupted, etc. as more often due to named cells.
These aren't RANGES, just single cells. I really like them because I also use them for repeated comments at the bottom of each table -- COMMENT1, COMMENT2. And other uses. So, does anyone know if what my co-workers are saying is true?
Also what are the other advantages of using named cells for single cells, over just putting in a cell address w/ $ $? Is there something I can quote?
Frankly, I just think they are jealous of my Excel prowess, lol.
But I would like to hear opinions about this!
In essence, we have about 50 worksheets with formulas related, for example, to FX rates. I have a worksheet called, "Input" that creates all sorts of single named cells for FX. In the named cells, I put the current FX for five countries, and name them as follows.
EURO
GBP
CAD
AUD
NZD
Then my formulas use the different names, where appropriate.
The thing is, we don't change anything else. So the formulas could as easily be linked to those cells with $ $ (e.g., $A$1), forever.
I have been told that I can no longer use named cells, because it "confuses" others looking at my files. When I objected -- as I sometimes look at the cells and "EURO" is easy to see that it is the FX I want, versus $A$1 -- they added, that named cells slow down performance in general and makes the file huge. They named other things -- files crashing, getting corrupted, etc. as more often due to named cells.
These aren't RANGES, just single cells. I really like them because I also use them for repeated comments at the bottom of each table -- COMMENT1, COMMENT2. And other uses. So, does anyone know if what my co-workers are saying is true?
Also what are the other advantages of using named cells for single cells, over just putting in a cell address w/ $ $? Is there something I can quote?
Frankly, I just think they are jealous of my Excel prowess, lol.
But I would like to hear opinions about this!