RE: Excel writes a formula on it's own - ??

Giganews Newsgroups
Subject: RE: Excel writes a formula on it's own - ??
Posted by:  John Bundy
Date: Wed, 1 Aug 2007

There are conditional formats that use functions, are you sure this isn't
happening? And are you sure there are no macros, if when you open the
workbook it asks if you want to enable macros you may have. If so try
disabling and then check for this occuring again. What hapens if you just
copy the entire sheet to another workbook?

Please rate when your question is answered to help us and others know what
is helpful.

"slreilly" wrote:

> Help!  I have a cell that has no formula - formatted as text. But as soon as
> I type a word into a second text formatted cell that first one autofills with
> a formula that makes it equal to the second one.
> i.e. if I type "test" into cell A12, then cell R12 automatically writes the
> formula =$A12
> And it's only on certain cells, not the whole sheet. I have no formula in
> either cell.  It's like conditional formatting only with formulas.
> I've tried copying a non-wonky cell & pasting it over the afflicted one.
> This works while the sheet is open, but as soon as I close & reopen it, it's
> back. What would cause this to happen? the cells in reference are
> DataValidation cells, but otherwise I have no code or macros associated with
> this sheet.



In response to

Excel writes a formula on it's own - ?? posted by slreilly on Wed, 1 Aug 2007