Custom views in excel keep changing

J

Julia AL

Hi

I have set up three custom views in Excel. However, if I make any further
changes to them e.g. hiding a column temporarily then it seems to
automatically change the custom view even though I am not saving it.

Also, I am using data filters in custom views and it clearly isn't happy
with them - they seem to disappear sometimes.

I'm wasting hours - please help! Thanks
 
C

Cestbon

Hi Julia,

You can only assign a custom view to the configuration at the time, further
changes will not be saved unless a new name is applied. To permenantly change
the view you must delete the current one and then add it again with the new
selection of columns hidden.

Cheers

Cestbon
 
J

Julia AL

Thanks for your reply. Unfortunately, it doesn't address my problem - the
point is that I DON'T want the custom views to change, but they seem to be
doing so on their own. I would like to be able to go back to them but they
never stay the same - I am not saving anything!

Any help greatly appreciated...

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top