Pat,
I'm experiencing a different kind of crash situation than any i've
seen in the post thus far...
I have a file that was created in Excel 2004 with 3 worksheets. One
of the worksheets has 92 lines of data (the spreadsheet is a file I
use to log sales & revenue information on a daily basis, before it is
inputted in the accounting system). So the data is text, dates, and
numbers.
For some reason, there is a small area of cells that, when a number is
entered, causes Excel to crash. In the original file, it was the
group of cells at E85:G89. The only way I could enter new lines of
data was to insert blank rows above row 81.
Additionally, I had formulas at the bottom of each column, in row 92,
that summed the column. There was then a formula in cell L92 that
summed across that row of totals. There was a group of cells at
I81:J91 that, when numbers were entered, were properly totaled at the
bottom of the column, but the formula in cell L92 was unaffected.
I recreated the file from scratch after closing Excel and restarting
(just to be safe), never opening the old file and entering data from a
printout I'd made of the old workbook. When I reached the same area
in this new file, I get the same errors.
Have you EVER heard of this error? It ONLY happens in this one
particular sheet in this one particular workbook. There are no macros
or pivot tables. There are links from the "bad" worksheet to another
worksheet within the workbook, but no links in the workbook that go to
any other file (though there are links in another file to this
particular workbook; that workbook has had no issues).
Any ideas?
Thanks!
Tony
