View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jamescox[_69_] jamescox[_69_] is offline
external usenet poster
 
Posts: 1
Default Converting xls to xlsm changes some names


Since Excel 2007 has so many more columns, old named ranges that start
with three letters (or even two letters that are 'greater' than the old
column limits) could reasonably interpreted by Excel as cell addresses.

Part of the up-convert apparently is to check named ranges for this
possibility and pre-pend an underscore where it is found.

Nothing to be done about it...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126950