Another Excel Problem

[JO]

I inherited this spreadsheet from someone who no longer works at my company and now I have to figure it out in order to use/modify it. My problem now is that I have cells that are calculating "stuff" but instead of referencing particular cells or areas (e.g. A1 or A1:A20), they reference names (e.g. STATCashFlows). My problem is that I can't find out what these names are refering to. I've tried :

1. clicking the Name Box.
2. Highlighting what I thought the areas were so that the name would appear in the name Box .
3. Insert, Name, Define.

but I can't find all of them. Is there a better way??

[Pseudolus]

Does "trace precedents" get you anywhere?

Might they be named ranges in other sheets? Check edit/links to see what sheets are being referenced.

(Sorry if these are both obvious things you've already done. Best I could come up with.)

[Obi-Wan Kenobi]

Find a safely blank area of the sheet. Then Insert Paste Paste list.

Insert Name - Define should do it. If the named variable / function / formula / etc is being used in that worksheet, it should show up on the list. But make sure you're on the same worksheet where it's used when you go to the Insert Name list (note: this might mean you need to go to multiple sheets and go to the list within each sheet. Different named variables sometimes show up). Even if it's a reference to another sheet, it should still show up on the list.

[JO]

Ah, trace precedents actually GET me somewhere, thanks. Hmm, so now I know what it references to but if I try to change the reference to include, say, another cell (expand the name), Insert, Name Define and use the name give me "Invalid Name".



OBK, did you mean, insert, name, paste?? If so, I get the same "list" than insert, name, define..

[JO]

urysohn, I thought Insert, Name Define would do it too but I'm missing A LOT of named area. All defined area of the entire workbook will appear when you do this, even if in a different worksheet. If so, the name of the worksheet will appear on the right of the named area/cell..

[Obi-Wan Kenobi]

Originally Posted by JO

OBK, did you mean, insert, name, paste?? If so, I get the same "list" than insert, name, define..

There should be a [Paste list] button when you do Insert, Name. That will give you your list in one handy, easy to see location.

[JO]

Uh?! :o

The only thing I have available when I select Insert, Name is :

Define..
Paste..
Create..
Apply..
Label..

[JO]

All right I love Microsoft. I couldn't redefine the range so I tried to mess around the name in the formula, then it told me that I had an error in my formula, "do you want to accept the corrections?" and I'm like "sure why not, it's so much fun anyway" and the correction had automatically updated the range to what I wanted it to be. Go figure..

[Obi-Wan Kenobi]

Oops. I left out a Paste.