Custom Views in Excel 97/2000/2002

  • Thread starter Thread starter StefV
  • Start date Start date
S

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
 
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
-------------------------------------------
StefV said:
Dear,

Since a while ago (when it still worked) we begin to have problems with
Click to expand...
one Excel-sheet and Custom Views.
The problem is that when we apply a custom view, Excel closes. We have
Click to expand...
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
Click to expand...
knows which setting needs to be altered.
 
Back
Top