 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008illegal name? [noobie, please be gentle]
re: xl2k I am attempting to name a column as "fy2007" xl refuses to accept this. Why? Note that "fy2007" appears to satisfy all the naming guidelines, as listed in the help file. Also note, "fy_2007" is acceptable. cheers, jw FY2007 looks like a cell in column FY in row 2007. You could name it FY_2007 or _FY2007 Or most anything that doesn't look like an address. > re: xl2k > [quoted text clipped - 8 lines] > > cheers, jw  SignatureDave Peterson fy is a column name 2007 is a row number Why? can't you name it _fy2007 or fy_2007 SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > re: xl2k > [quoted text clipped - 8 lines] > > cheers, jw On Jan 25, 9:28 am, mr_unreliable <kindlyReplyToNewsgr...@notmail.com> wrote: > re: xl2k > [quoted text clipped - 8 lines] > > cheers, jw fy2007 doesn't satisfy the "Can't be a like a cell address" guidline. xl2000 only has 256 columns but what about when they release an excel version with at least 2007 columns? Then your worksheet would have problems in that version if that guidline was restricted to the current version's number of columns. Ken Johnson > On Jan 25, 9:28 am, mr_unreliable <kindlyReplyToNewsgr...@notmail.com> > wrote: [quoted text clipped - 19 lines] > > Ken Johnson Oops! I confused columns and rows. Excel2000 has over 65000 rows so fy2007 doesn't satisfy the "Can't be a like a cell address" guidline. Ken Johnson Because fy2007 is actually a cell reference. That is...column FY and row 2007. Regards, Paul > re: xl2k > [quoted text clipped - 8 lines] > > cheers, jw Thanks for your replies. It didn't dawn on me that fy was a legitimate column identifier, as I rarely (if ever) get beyond the first alphabet. cheers, jw Just a warning... If you're using xl2003 or below, be careful. You'll want to stay away from names that look like addresses in xl2007 (million rows by 16k columns). If/when you upgrade to xl2007, you'll be happy that you don't have to fix these names. > Thanks for your replies. > > It didn't dawn on me that fy was a legitimate column identifier, > as I rarely (if ever) get beyond the first alphabet. > > cheers, jw SignatureDave Peterson Which is to say XFD1048576 is a cell address! Which means that some legal names in 2003 aren't legal in 2007. Cheers, Shane > Just a warning... > [quoted text clipped - 12 lines] >> >> cheers, jw Thu, 24 Jan 2008 17:53:11 -0600 from Dave Peterson <petersod@verizonXSPAM.net>: > If you're using xl2003 or below, be careful. You'll want to stay > away from names that look like addresses in xl2007 (million rows by > 16k columns). > > If/when you upgrade to xl2007, you'll be happy that you don't have > to fix these names. I was wondering about that. If I have a defined name JJ2 in my Excel 2003 workbook, and it points to a single cell, and somewhere I have a formula =JJ2+11, what does Excel 2007 do with that? One would hope it gives priority to user-defined names, but ..... SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.