excel xp training - Naming ranges

The UK's most regular instructor-led training courses.
Training information: excel xp training · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Naming ranges

Erica has attended:
Excel Advanced course

by - delegate Erica [2 posts] (2007 Mar 20 Tue, 12:28) Reply

I am having difficulty replacing formulas with names. I have defined the name and they show in the box but when i go to apply the named range it says it can't find a reference. can you help?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Naming ranges

by - trainer Richard platinum contributer [785 posts] (2007 Mar 22 Thu, 13:43) Reply

I suggest creating a new formula, from scratch, using the actual range, and then using the apply command to see if you can get it to work.

Another step could be to check that the original formula contains exactly the same range as the named range.

· Excel Macros for the Non-Programmer
· Compare Different MS Excel Training Methods
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How to Create Better Excel Spreadsheets: Part One
· Crazy Things People Have Done With Excel

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips