excel_frustrated
New Member
- Joined
- Aug 14, 2014
- Messages
- 1
I posted the same question to Stack Exchange, but was thinking this might be a better forum to solve my issue....
I created a workbook in Excel 2007 that has many dynamic named ranges. They all use the OFFSET function. An example is name of range is "date", worksheet is "Sheet1", and Refers to is <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background: rgb(238, 238, 238);">=OFFSET('Sheet1'!$N$3;0;0;COUNTA(!$N:$N);1)</code>. I use these dynamic named ranges as the data selection for charts.
My issue is that when I attempt to open my workbook in Excel 2010, Excel immediately crashes. I determined the issue was with using my dynamic named ranges for the chart data selection. I created a new workbook and created the named dynamic range (like described above) with no issue. But the moment I set the named dynamic range as the data selection for a chart Excel crashed!
Any idea if I'm doing something wrong? Any idea for a workaround?
I've uploaded a sample here: ge.tt/3Gu6fBr1/v/0 To enact the "bug" set the chart data in the first chart to x-series to <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(68, 68, 68); line-height: 17.280000686645508px; background: rgb(238, 238, 238);">=Sheet1!date</code>, and the y-series to <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(68, 68, 68); line-height: 17.280000686645508px; background: rgb(238, 238, 238);">=Sheet1!pctOk</code>.
I created a workbook in Excel 2007 that has many dynamic named ranges. They all use the OFFSET function. An example is name of range is "date", worksheet is "Sheet1", and Refers to is <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background: rgb(238, 238, 238);">=OFFSET('Sheet1'!$N$3;0;0;COUNTA(!$N:$N);1)</code>. I use these dynamic named ranges as the data selection for charts.
My issue is that when I attempt to open my workbook in Excel 2010, Excel immediately crashes. I determined the issue was with using my dynamic named ranges for the chart data selection. I created a new workbook and created the named dynamic range (like described above) with no issue. But the moment I set the named dynamic range as the data selection for a chart Excel crashed!
Any idea if I'm doing something wrong? Any idea for a workaround?
I've uploaded a sample here: ge.tt/3Gu6fBr1/v/0 To enact the "bug" set the chart data in the first chart to x-series to <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(68, 68, 68); line-height: 17.280000686645508px; background: rgb(238, 238, 238);">=Sheet1!date</code>, and the y-series to <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(68, 68, 68); line-height: 17.280000686645508px; background: rgb(238, 238, 238);">=Sheet1!pctOk</code>.