M
MattW
When trying to save a document from xls to xlsx format, I'm receiving a ton
of errors like the following: "The name, [11]_1_WEBI_DataGrid, either
conflicts with a valid range reference or is invalid for Excel." I've read
the previous posts on this problem, and have searched everywhere in this
document for values, formulas, comments, defined names, function names,
vbcode, formula contents, etc. and cannot find anything matching these names
within the document. If I open the xls in notepad (futile, I know, but I had
to find them somewhere.) I can see them all there, nestled among wingdings, I
just have no idea where they are within Excel or how to find them. It
wouldn't be so bad if the document didn't lose its formatting when this
happens.
of errors like the following: "The name, [11]_1_WEBI_DataGrid, either
conflicts with a valid range reference or is invalid for Excel." I've read
the previous posts on this problem, and have searched everywhere in this
document for values, formulas, comments, defined names, function names,
vbcode, formula contents, etc. and cannot find anything matching these names
within the document. If I open the xls in notepad (futile, I know, but I had
to find them somewhere.) I can see them all there, nestled among wingdings, I
just have no idea where they are within Excel or how to find them. It
wouldn't be so bad if the document didn't lose its formatting when this
happens.