Share via

error when saving in excel 2010

Anonymous
2012-09-22T15:32:05+00:00

how do I correct the following error in excel 2010

The Name, vcm14, either conflicts with a valid range reference or is invalid for Excel.  The name has been replaced with _vcm14.

You may still need to manually update an references to this name used in VBA code or as text arguments in functions. You must close and reopen the workbook before these changes take effect.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-09-24T01:09:22+00:00

    As I noted in earlier message, the term VCM14 is a valid cell reference in XL2007 and all later versions.

    You might try doing a Save As ans saving the file as an XLS (Excel 1997-2003) file.

    Let us know if this works.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-09-23T23:38:16+00:00

    Thks Bernard,

    But I'm only attempting to save the file, I don't know who created the workbook and I have no knowledge of VBA code.  Would it be possible to go back to XL2007 version and this would solve the problem?   any other suggestions?  I appreciate the help.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-09-22T15:42:45+00:00

    Looks like somewhere (in your VBA code or in Name Manager)  you have named a cell/range as vcm14. But this is a valid cell reference in XL 2007 and on. best wishes

    Was this answer helpful?

    0 comments