Custom Views in Excel 97/2000/2002

Dear,

Since a while ago (when it still worked) we begin to have problems with one Excel-sheet and Custom Views.

The problem is that when we apply a custom view, Excel closes. We have tried this with Excel 97/2000 or 2003, and this gives the same error. Excel closes!!!
When we try to create a new Custom View, Excel closes down...

Does anyone has an answer to my serious problem or is there anyone who knows which setting needs to be altered.

I can't attach the file because it's private information.

Please help me!!!!

Thx

StefV
Belgium

Just some thoughts.
(I'm in xl97)

When you last edited the file...
did you protect sheet
after hiding some rows / columns, etc
which were previously visible in the custom views?

If you did, then you'll probably hit the error:
"Some view settings could not be applied"
when you activate the custom view

Tried hiding a sheet with custom views,
then protecting workbook
Tried activating the custom views (for the hidden sheet)
- nothing happened (due to workbook protection)
but there was no error message

I couldn't replicate Excel closing with error
(not even with deleting some columns/rows
visible in earlier saved custom views, then activating
these custom views)

Maybe consider experimenting:

Copy over the "problem" sheet to a new book save.
Then open and try creating the custom views save

If the views work in the new book,
try copying this problem sheet back
to a *back-up copy* of the original book,
and recreate the same views...
--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
atyahoodotcom
for email
-------------------------------------------
"StefV" wrote in message
.be...
Dear,

Since a while ago (when it still worked) we begin to have problems with
one Excel-sheet and Custom Views.

The problem is that when we apply a custom view, Excel closes. We have
tried this with Excel 97/2000 or 2003, and this gives the same error. Excel
closes!!!
When we try to create a new Custom View, Excel closes down...

Does anyone has an answer to my serious problem or is there anyone who
knows which setting needs to be altered.

I can't attach the file because it's private information.

Please help me!!!!

Thx

StefV
Belgium