Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom views in excel keep changing
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom views in excel keep changing
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 "Julia AL" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom views in excel keep changing
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 "Cestbon" wrote: 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 "Julia AL" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
How do I get custom views created in Excel 2K to show in Excel 200 | Excel Worksheet Functions | |||
How to password protect hidden columns and custom views in Excel | Excel Discussion (Misc queries) | |||
Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) |