Solve : Excel 2000 range name problem on ME and on Vista Home...?

1.	Solve : Excel 2000 range name problem on ME and on Vista Home...?
Answer» Excel 2000 problem noticed on ME first (and put down to ME's age!) and then strangely on Vista Home...a ranges name is shown in the cell itself superimposed on top of the value in the cell. Well that's the LONG and the short and I can't add much other than to SAY, I have found no CLUE as to why it happens or how to turn it off but wonder whether it is SOMETHING in Vista compatibility settings for excel 2000. N.B. The particular FILE in question has macros which were 99% written in Excel 2000 and 1% in 2007 but there is no reason of which I am aware as to suspect incompatibility. Thanks.Have you tried a Repair install of Office ? ?If you open a blank spreadsheet (with no macros) and name a few ranges, does the same behavior occur?

Discussion