Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 not saving user-created range names
We recently had Office 2007 installed here (running on XP) and are
experiencing problems with named ranges in Excel. Excel is in some instances not saving user-created named ranges. In a typical case, I will define the range, save the file, close the file and reopen, and the name will not be there. ("I put that name in yesterday. Where did it go?") The work-around is to use a different name and that seems to work so far. My names contain no special characters (all alpha), and Excel gives no warning about invalid name, or the fact that it will delete that name (? upon closing the file). This is creating a huge problem for us since I use numerous vlookups in downstream files that reference named ranges. The files were created in a previous version (2003) and I had no problem whatsoever in that version. When we got 2007, I saved them in the Macro-enabled format since some of these files have macros. I wonder if that is the source of the problem -- should I be saving them to the default format? I've done a cursory search in Google and this discussion group, and have been unable to find anything on this particular problem with Excel 2007. Has anyone had this problem, and/or know the solution? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Assigning Range Names in one spreadsheet/worksheet | Excel Discussion (Misc queries) | |||
Shared excel (2000) file not saving for one user | Excel Discussion (Misc queries) | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
Problem using newly created user function in Excel 2003 | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) |