Excel fill failure

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?

This is not a Vista problem, check link below and select appropriate
discussion group>
http://www.microsoft.com/office/comm...tOverview.mspx
--
Regards
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.



"johnthebaptist" wrote:

> 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?

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?

"Bob J" wrote:

> This is not a Vista problem, check link below and select appropriate
> discussion group>
> http://www.microsoft.com/office/comm...tOverview.mspx
> --
> Regards
> 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.
>
>
>
> "johnthebaptist" wrote:
>
> > 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?

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!

"Bob J" wrote:

> This is not a Vista problem, check link below and select appropriate
> discussion group>
> http://www.microsoft.com/office/comm...tOverview.mspx
> --
> Regards
> 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.
>
>
>
> "johnthebaptist" wrote:
>
> > 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?

I use Office 2007 and have found the groups very helpful, normally there is
someone who will help solve problems.
Goodluck
--
Regards
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.



"johnthebaptist" wrote:

> 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?