software

I have 5-6 charts in my spreadsheet. I have made several dynamic... meaning
the update automaticly if I add new data to my sheet. The process has worked
fine on several of them. However, on one worsheet in my file, I cannot for
the life of me figure out why excel crashes when I name a range in my
spreadsheet or if I try to put in a named range in the source data of my
chart.Here is what crashes my file.

CCB is the chart categories which is the formula
=OFFSET(Bills!$B$35,CLX,0,-CLX)
CLX is the count of the number of items to display =COUNT($D$36:$D$63)

the only problem I see is that when I go into look at how the named ranges
are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ... if
I change that to the above formula it crashes... Keep in mind this exact
idea works on another identical sheet.

HELP!

I have no problem with the setup, confirming that it works in other sheets.
I'd suggest that you stop beating your head against the wall, and rebuild
the difficult sheet. Sometimes sheets and workbooks can get corrupt.

BTW, this formula
=OFFSET(Bills!$B$35,CLX,0,-CLX)

is equivalent to
=OFFSET(Bills!$B$35,1,0,CLX)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Johnquot; gt; wrote in message
...
gt;I have 5-6 charts in my spreadsheet. I have made several dynamic...
gt;meaning
gt; the update automaticly if I add new data to my sheet. The process has
gt; worked
gt; fine on several of them. However, on one worsheet in my file, I cannot
gt; for
gt; the life of me figure out why excel crashes when I name a range in my
gt; spreadsheet or if I try to put in a named range in the source data of my
gt; chart.
gt;
gt;
gt; Here is what crashes my file.
gt;
gt; CCB is the chart categories which is the formula
gt; =OFFSET(Bills!$B$35,CLX,0,-CLX)
gt; CLX is the count of the number of items to display =COUNT($D$36:$D$63)
gt;
gt; the only problem I see is that when I go into look at how the named ranges
gt; are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ...
gt; if
gt; I change that to the above formula it crashes... Keep in mind this exact
gt; idea works on another identical sheet.
gt;
gt; HELP!
I agree, corrupted. Thanks

quot;Jon Peltierquot; wrote:

gt; I have no problem with the setup, confirming that it works in other sheets.
gt; I'd suggest that you stop beating your head against the wall, and rebuild
gt; the difficult sheet. Sometimes sheets and workbooks can get corrupt.
gt;
gt; BTW, this formula
gt; =OFFSET(Bills!$B$35,CLX,0,-CLX)
gt;
gt; is equivalent to
gt; =OFFSET(Bills!$B$35,1,0,CLX)
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt;I have 5-6 charts in my spreadsheet. I have made several dynamic...
gt; gt;meaning
gt; gt; the update automaticly if I add new data to my sheet. The process has
gt; gt; worked
gt; gt; fine on several of them. However, on one worsheet in my file, I cannot
gt; gt; for
gt; gt; the life of me figure out why excel crashes when I name a range in my
gt; gt; spreadsheet or if I try to put in a named range in the source data of my
gt; gt; chart.
gt; gt;
gt; gt;
gt; gt; Here is what crashes my file.
gt; gt;
gt; gt; CCB is the chart categories which is the formula
gt; gt; =OFFSET(Bills!$B$35,CLX,0,-CLX)
gt; gt; CLX is the count of the number of items to display =COUNT($D$36:$D$63)
gt; gt;
gt; gt; the only problem I see is that when I go into look at how the named ranges
gt; gt; are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ...
gt; gt; if
gt; gt; I change that to the above formula it crashes... Keep in mind this exact
gt; gt; idea works on another identical sheet.
gt; gt;
gt; gt; HELP!
gt;
gt;
gt;