Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi all,
I have a problem that I can reproduce on Excel 2000 and Excel 2003 (but not in Excel 2007). Excel crashes when I try to re-position a chart in a worksheet with (at least) a cell using data validation. If I select a cell with Data-Validation a little triangle appears close to the cell to indicate it has a pull-down menu associated. If a chart is present on the spreadsheet and I click on it the "little triangle" disappears as soon as focus is taken by the chart. In some of my spreadsheet there is a delay before the triangle disappears and if a chart is dragged at this time Excel crashes. This makes me think that there is a problem with the sequence of events that happen within Excel when the window is re-drawn when cells have some form of validation. The following sequence reproduce the problem: 1. Open Excel 2. Move cursor to cell A1 if not there already 3. Menu-Data-Validation-Settings. And select: Allow: "List", Source: "AAA,BBB" 4. Move cursor to cell A2 5. Press on the toolbar button for "Chart Wizard" and press Finish (this will select an empty graph of type: Column) 6. Move cursor to cell A1 (the little triangle showing the pull-down menu should appear) 7. With the "little triangle" visible, click on the graph and drag it (possibly as a single action). At step (7) Excel crashes. Does anyone know if this problem has been fixed with SP3? (my company hasn't rolled it out yet and there are no plans to, so I cannot check this, but if it was fixed I would have a valid reason to require the service pack to be rolled out). Or has it been fixed in any hotfix? thanks gc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel crashes | Excel Discussion (Misc queries) | |||
VBA excel crashes | Excel Discussion (Misc queries) | |||
Dragging data onto a chart | Charts and Charting in Excel | |||
Excel 200 crashes | Excel Discussion (Misc queries) | |||
Excel Crashes on me | Excel Discussion (Misc queries) |