| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting one name to different names in columns | Excel Discussion (Misc queries) | |||
| Converting numbers to month names | Excel Discussion (Misc queries) | |||
| Converting full Names from 1 cell to 2 | Excel Discussion (Misc queries) | |||
| Finding unique names--then converting those names to unique number | Excel Discussion (Misc queries) | |||
| need help converting text codes to names | Excel Worksheet Functions | |||
![jamescox[_69_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
