Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Crestview Hills, Kentucky, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Phantom Formula (Excel 2002)

    We have a worksheet that does the following:

    A value is entered into A3. There is a formula in G3 that reads "=A3." So, when a value is entered into A3, the value also appears in G3. Very simple, right?

    Here's what I can't figure out. In some rows of the worksheet, the value entered into, say, A32, appears in E32 as well as G32. When I select E32, the formula is "=A32" even though before entering a value in A32, there is NO formula in E32.

    Any ideas what might be going on?

    Thanks,
    Craig.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Formula (Excel 2002)

    It could be caused by the "Extend list formats and formulas" option. See XL2000: How Auto Extend List Behavior Works (applies to later versions too).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •