Excel fill failure

[Guest]

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?

 

[Guest]

This is not a Vista problem, check link below and select appropriate
discussion group>
http://www.microsoft.com/office/community/en-us/FlyoutOverview.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.

 

[Guest]

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?

 

[Guest]

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!

 

[Guest]

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.