LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel.exe failure when copy & paste [email protected] Excel Discussion (Misc queries) 0 February 16th 07 05:11 PM
E-Mail Attachment Failure - Excel 2007 BLeonard3 Excel Discussion (Misc queries) 4 January 17th 07 04:01 PM
Excel 2003 update failure Jamie New Users to Excel 0 April 7th 06 02:52 AM
Howeractivate Excel after a macro failure John Excel Worksheet Functions 1 March 3rd 06 09:44 PM
Excel 2003 Link failure Alexander Fry Links and Linking in Excel 0 May 20th 05 02:51 AM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"