L
larsbennbom
Hello!
My problem is that Excel crashes when i open one of my files.
I have experienced this only ones before in all of theese years I hav
been using Excel.
Some input:
- Currently I'm using Excel 2000.
The file that causes Excel to crash:
- It is a workbook for consolidating subsidiaries to an operationa
financial statement.
- It has 16 sheets,
- References between the sheets,
- The sheet where one can see the consolidated statement compared t
budget or forecast contains formulas with "If" and "Index" function
Used with a "Forms, combination box"
- It has external links to other spreadsheets. (although when replace
with values still caused Excel to crash (see below).
Macro code:
- For locking sheets when workbook is closed.
- Button: For unlocking all sheets (when I want to update externa
links).
- Button: For viewing columns where I choose which rows are to be show
in detailed or summary mode.
Problem:
When I open Excel and choose the file to be opened (or double click th
file directly), I first get the question about allowing macros to be ru
or not (I have tried both), the message box disapears (as it should) an
Excel continues. After a few seconds it crashes and I get the questio
if I want to send the error message to Microsoft.
The computer and operating system still works properly. And I ca
restart Excel and continue working (except with that file, of course).
I have also tried with that file to replace all external links and Nam
definitions so that ther are no links. Still no succes!
That is all.
Do you have any solution to that you would want to share - I would b
gratefull!
/Lar
My problem is that Excel crashes when i open one of my files.
I have experienced this only ones before in all of theese years I hav
been using Excel.
Some input:
- Currently I'm using Excel 2000.
The file that causes Excel to crash:
- It is a workbook for consolidating subsidiaries to an operationa
financial statement.
- It has 16 sheets,
- References between the sheets,
- The sheet where one can see the consolidated statement compared t
budget or forecast contains formulas with "If" and "Index" function
Used with a "Forms, combination box"
- It has external links to other spreadsheets. (although when replace
with values still caused Excel to crash (see below).
Macro code:
- For locking sheets when workbook is closed.
- Button: For unlocking all sheets (when I want to update externa
links).
- Button: For viewing columns where I choose which rows are to be show
in detailed or summary mode.
Problem:
When I open Excel and choose the file to be opened (or double click th
file directly), I first get the question about allowing macros to be ru
or not (I have tried both), the message box disapears (as it should) an
Excel continues. After a few seconds it crashes and I get the questio
if I want to send the error message to Microsoft.
The computer and operating system still works properly. And I ca
restart Excel and continue working (except with that file, of course).
I have also tried with that file to replace all external links and Nam
definitions so that ther are no links. Still no succes!
That is all.
Do you have any solution to that you would want to share - I would b
gratefull!
/Lar