Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Freeze Pane with List boxes
Hi All,
I have an excel sheet, a pretty huge one, that queries ANALYSIS CUBES (database) to get the data onto its sheet. I have a sheet where a particular set of columns are frozen in the left. Since the sheet which is a report has data for months, I'll have to scroll to the right of the sheet. When I do so, a set of list boxes that are placed on the frozen area are moved from their original location. The more I scroll to the right, the more it moves to the left and disappears and the list box loses its functionality. I am using EXcel 2003, heard about a similar byg in Excel '97. Can anyone help me out with this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Freeze Pane with List boxes
Hi,
I am not able to reproduce the scenario. It works fine on my system. Some clarification: 1. Have you created a list using Data -List- Create List. That means your list has arrows on the header. Am I right? 2. Do you mean List converted to range. Challa Prabhu " wrote: Hi All, I have an excel sheet, a pretty huge one, that queries ANALYSIS CUBES (database) to get the data onto its sheet. I have a sheet where a particular set of columns are frozen in the left. Since the sheet which is a report has data for months, I'll have to scroll to the right of the sheet. When I do so, a set of list boxes that are placed on the frozen area are moved from their original location. The more I scroll to the right, the more it moves to the left and disappears and the list box loses its functionality. I am using EXcel 2003, heard about a similar byg in Excel '97. Can anyone help me out with this problem? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Freeze Pane with List boxes
On Aug 25, 11:50 am, challa prabhu
wrote: Hi, I am not able to reproduce the scenario. It works fine on my system. Some clarification: 1. Have you created a list using Data -List- Create List. That means your list has arrows on the header. Am I right? 2. Do you mean List converted to range. Challa Prabhu " wrote: Hi All, I have an excel sheet, a pretty huge one, that queries ANALYSIS CUBES (database) to get the data onto its sheet. I have a sheet where a particular set of columns are frozen in the left. Since the sheet which is a report has data for months, I'll have to scroll to the right of the sheet. When I do so, a set of list boxes that are placed on the frozen area are moved from their original location. The more I scroll to the right, the more it moves to the left and disappears and the list box loses its functionality. I am using EXcel 2003, heard about a similar byg in Excel '97. Can anyone help me out with this problem?- Hide quoted text - - Show quoted text - Hi Challa, I am not sure of the data validation part, I am debugging someone else's code. If that validation list is something where I cannot enter my own values, then I cant do that in the sheet!!!! I meant a Dropdown box as a list :-(, the dropdown moves outta place!!!! Mny Thanks, ~Haarish |
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) | |||
In Excel can you select freeze pane and split screen on same page | Setting up and Configuration of Excel | |||
How do I freeze a pane on Excel but leave one line unfrozen? | Excel Discussion (Misc queries) | |||
In Excel allow freeze pane in any column plus any row | Excel Worksheet Functions | |||
Excel should allow me to freeze pane in a split window | Excel Worksheet Functions |