excel 2004 crashes when making formula involving references between sheets

[paul]

I am having repeated crashes with excel 2004 when creating formulas
that involve cells on seperate sheets of a workbook. It seems to be
when i add a sheet on a workbook created with excel 97 PC and then
make references to cells on other sheets of that workbook. everytime i
intend to click on the sheet or on the tab of the sheet, excel
systematically crashes. It always happens with the same sheets but i
have not yet found out what features of the sheet make excel crash.
does anyone have an idea?

paul
(e-mail address removed)

 

[JE McGimpsey]

I am having repeated crashes with excel 2004 when creating formulas
that involve cells on seperate sheets of a workbook. It seems to be
when i add a sheet on a workbook created with excel 97 PC and then
make references to cells on other sheets of that workbook. everytime i
intend to click on the sheet or on the tab of the sheet, excel
systematically crashes. It always happens with the same sheets but i
have not yet found out what features of the sheet make excel crash.
does anyone have an idea?

It sounds like your workbook is corrupted. Copy each sheet to a new
workbook (Select all, Copy, select a sheet in the the new workbook and
paste).

 

[bucht]

The problem is that it happens with many many workbooks. it's always
when i create a workbook that combines sheets from previous versions of
excel. Would be happy to send you an example if you want because it's
really annoying. p

 

[bucht]

I have found why this happens, and it seems to affect all workbooks
that have 'freeze panes' turned on. Try it yourself: 1.create a new
workbook.2. on one sheet type a few numbers and then freeze panes 3, on
another sheet create a formula that involve numbers on the first sheet.
4.When you are typing the formula, the minute you click on the tab of
the first sheet or if you navigate to it by ctrl-fn-down arrow, when
you click on the sheet excel will crash. This therefore seem to be
linked to freeze panes.
Any idea how to fix it or how to report it to the mac excel team?

p

 

[bucht]

I have found why this happens, and it seems to affect all workbooks
that have 'freeze panes' turned on. Try it yourself: 1.create a new
workbook.2. on one sheet type a few numbers and then freeze panes 3, on
another sheet create a formula that involve numbers on the first sheet.
4.When you are typing the formula, the minute you click on the tab of
the first sheet or if you navigate to it by ctrl-fn-down arrow, when
you click on the sheet excel will crash. This therefore seem to be
linked to freeze panes.
Any idea how to fix it or how to report it to the mac excel team?

p

 

[JE McGimpsey]

I have found why this happens, and it seems to affect all workbooks
that have 'freeze panes' turned on. Try it yourself: 1.create a new
workbook.2. on one sheet type a few numbers and then freeze panes 3, on
another sheet create a formula that involve numbers on the first sheet.
4.When you are typing the formula, the minute you click on the tab of
the first sheet or if you navigate to it by ctrl-fn-down arrow, when
you click on the sheet excel will crash. This therefore seem to be
linked to freeze panes.
Any idea how to fix it or how to report it to the mac excel team?

Posting this reports to the MacBU XL team.

However, I just tried to replicate your steps, and didn't crash.
However, I'm using XL 11.1 (SP1). Have you updated yet?

If so, here's what I did.

1) Created a new workbook.
2) Entered random numbers in Sheet1, A1:B20
3) Switched to Sheet2
4) In cell A1, entered "=SUM("
5) Clicked on the Sheet1 Tab.
6) Selected Sheet1!A1:B10
7) Hit the Return key.

XL switched back to Sheet2, and my formula,

=SUM(Sheet1!A1:B10)

was entered in Sheet2!A1.

Did I miss something?