Excel Crashes

R

raufglasgow

I have the same problem as Tony. Has this problem been resolved. I
have encountered the crashing problem both on Leopard and Tiger
running Excel 12.1.4. It is very frustrating, but I see no solution
since I am running the latest version of excel.

Sorry, I thought I was adding to a different thread. I have quoted the
problem I was referring too.


Newsgroups: microsoft.public.mac.office.excel
From: (e-mail address removed)
Date: Tue, 25 Mar 2008 08:21:59 -0700 (PDT)
Local: Tues, Mar 25 2008 7:21 am
Subject: Re: Excel crashing randomly
Reply to author | Forward | Print | Individual message | Show original
| Report this message | Find messages by this author
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
 
B

Bob Greenblatt

I have the same problem as Tony. Has this problem been resolved. I
have encountered the crashing problem both on Leopard and Tiger
running Excel 12.1.4. It is very frustrating, but I see no solution
since I am running the latest version of excel.

Sorry, I thought I was adding to a different thread. I have quoted the
problem I was referring too.


Newsgroups: microsoft.public.mac.office.excel
From: (e-mail address removed)
Date: Tue, 25 Mar 2008 08:21:59 -0700 (PDT)
Local: Tues, Mar 25 2008 7:21 am
Subject: Re: Excel crashing randomly
Reply to author | Forward | Print | Individual message | Show original
| Report this message | Find messages by this author
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
I have no idea, but will be happy to look at the sheet. If it contains
confidential information, just delete the numbers and leave all the
formulas.
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top