LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
gc gc is offline
external usenet poster
 
Posts: 13
Default Excel crashes dragging a chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel crashes Matt Excel Discussion (Misc queries) 0 April 20th 07 07:52 PM
VBA excel crashes Jeff Excel Discussion (Misc queries) 0 November 3rd 06 03:43 PM
Dragging data onto a chart user dan Charts and Charting in Excel 1 October 5th 06 07:33 PM
Excel 200 crashes Jeremy Ricketts Excel Discussion (Misc queries) 1 September 24th 06 07:49 PM
Excel Crashes on me Andrew Excel Discussion (Misc queries) 5 August 31st 06 01:28 PM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"