Excel fill failure

Discussion in 'Windows Vista Performance' started by johnthebaptist, Nov 10, 2007.

  1. I have Windows Vista Home Basic running Office Standard 2007

    This is my homemade checking account. The balance formula is
    I153-G154+H154, where I153 is the previous balance, G154 is a new debit and
    H154 is a new credit.

    Normally when I fill the resulting balance further down column I, it shows
    the balance repeated. This has been working fine from the start months ago.
    Today it repeated the resulting balance in the next row, 155, yielded by the
    filled formula I154-G155+H155, the latter two being empty cells as always.

    Thereafter, rows 156 and following, the correct filled formula is repeated
    in column I, but a #VALUE error is returned instead of the repreated previous
    balance. The error message is: "A value in the formula is of the wrong data
    type." I156 and downward adds a green triangle in the upper left cell
    corner. This does not appear in the cells above it.

    My eMachine would neither restart not shut down programmatically. I had to
    power down manually. Rebooting normally did not solve the problem. What's
    going on?
    johnthebaptist, Nov 10, 2007
    1. Advertisements

  2. johnthebaptist

    Bob J Guest

    Bob J, Nov 10, 2007
    1. Advertisements

  3. Thanks, Bob J.

    The Excel groups for Worksheet Functions and for Programming don't touch my
    problem, or seem to. None of the remaining Excel groups seem promising.
    Where to from here? I guess I can copy the last few checkbook entries to
    another sheet in the same workbook or into a new workbook and see what
    happens. Any better ideas?
    johnthebaptist, Nov 10, 2007
  4. After getting back to you I realized I should have copied and submitted my
    problem to the Excel discussion group on Excel Worksheet Functions. This I
    did, and Pete_UK solved it by suggesting that I had entered one or more
    spaces in G155:H155 filled downward. On that premise I needed to select that
    range and hit <delete>. When I did, my last balance figure filled downward
    as usual! To check, I entered a space in H155 and all the mystery data below
    that popped up again in the I column.

    Your lead got me there, Bob J. Thanks much!
    johnthebaptist, Nov 11, 2007
  5. johnthebaptist

    Bob J Guest

    I use Office 2007 and have found the groups very helpful, normally there is
    someone who will help solve problems.
    Bob J
    If advise given from anyone, solves problem or not, or if solved from
    another source,post back & let us know.
    Then we all benefit.
    Bob J, Nov 11, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.