Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Panes v/s List
This is a constant niggle that I have not solved.
My team has several workbooks for tracking documentation. I have set them up as Lists for ease of entry and analysis. I've set Freeze Panes to show the first row and top column. Nothing is protected, the workbooks are not set to shareable. They are not huge: the biggest has about 1000 rows and 16 columns. If I work on a workbook by changing, deleting, adding, re-ordering, filtering records, refreshing pivot tables (on non-frozen sheets), and reopen it, the freeze-panes probably still work; but if I open it again tomorrow after colleagues have done the same sort of work, I may or may not find that the freeze has thawed. I know I said 'filtering' there but I always Show All before finishing, and usually the freeze stays when I do this. My colleagues deny changing these settings and have noticed the problem too. Is this a feature I must accept, or am I missing something silly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Panes v/s List
freeze panes don't disappear by themselves. Somebody somewhere did it. You
can write a Workbook_Open event procedure to ensure they are frozen where you want each time. "Jonathan589" wrote: This is a constant niggle that I have not solved. My team has several workbooks for tracking documentation. I have set them up as Lists for ease of entry and analysis. I've set Freeze Panes to show the first row and top column. Nothing is protected, the workbooks are not set to shareable. They are not huge: the biggest has about 1000 rows and 16 columns. If I work on a workbook by changing, deleting, adding, re-ordering, filtering records, refreshing pivot tables (on non-frozen sheets), and reopen it, the freeze-panes probably still work; but if I open it again tomorrow after colleagues have done the same sort of work, I may or may not find that the freeze has thawed. I know I said 'filtering' there but I always Show All before finishing, and usually the freeze stays when I do this. My colleagues deny changing these settings and have noticed the problem too. Is this a feature I must accept, or am I missing something silly? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Panes v/s List
Thank you for your rapid and clear response. I thought I was having senior
moments or that MS had smuggled in something odd. I will look into the event procedure writing if I cannot control my colleagues. "Bob Umlas, Excel MVP" wrote: freeze panes don't disappear by themselves. Somebody somewhere did it. You can write a Workbook_Open event procedure to ensure they are frozen where you want each time. "Jonathan589" wrote: This is a constant niggle that I have not solved. My team has several workbooks for tracking documentation. I have set them up as Lists for ease of entry and analysis. I've set Freeze Panes to show the first row and top column. Nothing is protected, the workbooks are not set to shareable. They are not huge: the biggest has about 1000 rows and 16 columns. If I work on a workbook by changing, deleting, adding, re-ordering, filtering records, refreshing pivot tables (on non-frozen sheets), and reopen it, the freeze-panes probably still work; but if I open it again tomorrow after colleagues have done the same sort of work, I may or may not find that the freeze has thawed. I know I said 'filtering' there but I always Show All before finishing, and usually the freeze stays when I do this. My colleagues deny changing these settings and have noticed the problem too. Is this a feature I must accept, or am I missing something silly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
freeze panes? | Excel Discussion (Misc queries) | |||
freeze panes? | New Users to Excel | |||
Freeze Panes | Excel Discussion (Misc queries) | |||
Can't freeze panes | Excel Worksheet Functions |