Custom Views in Excel 97/2000/2002

[StefV]

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

 

[Max]

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
<at>yahoo<dot>com
for email
-------------------------------------------

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.