( Let’s name it Scenario B.) The reason why the first step in this is selecting. On the next window, give your scenario a title or a name. On the ‘Scenario Manager’ window, click on the ‘Add’ button. I get the 'Your formula has an error and the sheet reference is highlighted in the formula bar. Then, follow these steps: Go to the ‘Data’ tab. So, If I am reading your answer correctly, I should be able to change the above to Over in D I define Trees to be a named range E2:J300 I'd rather define it in D and use it where I wish. Searching for help, I can define it as a named range in the destination workbook, but his will require redefining it in every workbook that uses D. In I.xls I want to use a VLOOKUP on one of D's named ranges.Ĭan I refer to D's named ranges in a formula? If so, what is the syntax? Names aren't associated with a sheet so the SheetName!explict_range syntax doesn't work. D.xls is a reference worksheet used to define commonly used infomation for a bunch of other worksheets.ĭ.xls has named ranges for this and that.

Name manager for mac excel