Random Characters appearing in cells

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

One of our users has complained about, and I have
witnessed, a simple name and address spreadsheet that
places the text +A1 in various cells, after the correct
cell contents. This spreadsheet is not shared with anyone
nor does anyone else have access to it, so that eliminates
someone else messing with it. The text normally appears
after she has made changes elsewhere in the spreadsheet,
saves and then closes it. When she opens it again the
previously mentioned mystery text appears. Any ideas??
Thank you.

Ken
 
Does the workbook have macros?

Try opening it with macros disabled. If this stops the problem, then you could
look for "helpful" macros.

If it only happens on one worksheet, try rightclicking on that worksheet's tab
and selecting View Code.

Do you see anything there?

And it could be under the ThisWorkbook module.

Debra Dalgleish has some pictures that may help (they're used for a different
purpose at her site) you look for the macros.

http://www.contextures.com/xlfaqMac.html#NoMacros

You'll want to look under the sheet modules and the ThisWorkbook especially.

=========

And one silly guess: Are you using xl2002? Do you have Speech recognition
turned on? (Not sure what could be misinterpreted as +A1, but....)
 
Did you check David McRitchie's suggestion.

Is there a pattern where it's added. Maybe after a close parenthesis:

=3*(c1+c2)
could get converted to
=3*(c1+c2)+a1

if someone had changed autocorrection of ) to )+A1
(could be after other characters, too.)

But I don't have another guess.
 
Back
Top