Looking to see if someone can help point me in the right direction with
determining why my spreadsheet (VERY large with a lot of ranges, variables)
is acting up. Up until recently the model worked perfect, recently I added
some model protection and user sign-on requirements, but dont have any
conflicts Im can see.

The issue: Some of my ranges are not updating, its like the model is not
recalculating or updating the ranges after each use. The user selects a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and so on,
the value is assigned to a named range, which drives pivot tables, the coping
of other ranges and so on. While doing some debugging, I noticed that the
named ranges are keeping the previous value.

Thanks for any help

My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance of Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation. You can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up. One way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message ...
Looking to see if someone can help point me in the right direction with
determining why my spreadsheet (VERY large with a lot of ranges, variables)
is acting up. Up until recently the model worked perfect, recently I added
some model protection and user sign-on requirements, but don't have any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model is not
recalculating or updating the ranges after each use. The user selects a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and so on,
the value is assigned to a named range, which drives pivot tables, the coping
of other ranges and so on. While doing some debugging, I noticed that the
named ranges are keeping the previous value.

Thanks for any help

Okay, Niek, spill the beans. Why didn't the text of your response get
truncated into short lines as does everyone else's? <G

Bob

"Niek Otten" wrote in message
...
My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened
unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened
determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance of
Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells
directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation. You
can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct
sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious
recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up. One
way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing
CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message
...
Looking to see if someone can help point me in the right direction with
determining why my spreadsheet (VERY large with a lot of ranges,
variables)
is acting up. Up until recently the model worked perfect, recently I
added
some model protection and user sign-on requirements, but don't have any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model is
not
recalculating or updating the ranges after each use. The user selects
a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and so
on,
the value is assigned to a named range, which drives pivot tables, the
coping
of other ranges and so on. While doing some debugging, I noticed that
the
named ranges are keeping the previous value.

Thanks for any help

Hi Bob,

I wish I knew!

It does here.
I've been struggling with template replies for some time now. If I use Word, I get double spaced lines, maybe you don't?
If I paste to Excel and paste from there into OE, it looks fine here (of course I tested a private reply first!)
Do you ever use pre-cooked replies and if so, how?

--
Kind regards,

Niek Otten

"Bob Phillips" wrote in message ...
Okay, Niek, spill the beans. Why didn't the text of your response get
truncated into short lines as does everyone else's? <G

Bob

"Niek Otten" wrote in message
...
My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened
unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened
determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance of
Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells
directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation. You
can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct
sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious
recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up. One
way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing
CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message
...
Looking to see if someone can help point me in the right direction with
determining why my spreadsheet (VERY large with a lot of ranges,
variables)
is acting up. Up until recently the model worked perfect, recently I
added
some model protection and user sign-on requirements, but don't have any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model is
not
recalculating or updating the ranges after each use. The user selects
a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and so
on,
the value is assigned to a named range, which drives pivot tables, the
coping
of other ranges and so on. While doing some debugging, I noticed that
the
named ranges are keeping the previous value.

Thanks for any help

Hi Niek,

No, I just use the bog-standard reply mechanism (excuse my gutter English).
I was hoping you had the solution, because we get so many problems with
wrap-around in code that it would solve.

Regards

Bob

"Niek Otten" wrote in message
...
Hi Bob,

I wish I knew!

It does here.
I've been struggling with template replies for some time now. If I use
Word, I get double spaced lines, maybe you don't?
If I paste to Excel and paste from there into OE, it looks fine here (of
course I tested a private reply first!)
Do you ever use pre-cooked replies and if so, how?

--
Kind regards,

Niek Otten

"Bob Phillips" wrote in message
...
Okay, Niek, spill the beans. Why didn't the text of your response get
truncated into short lines as does everyone else's? <G

Bob

"Niek Otten" wrote in message
...
My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened
unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened
determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance of
Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells
directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation.
You
can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct
sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious
recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up. One
way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing
CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message
...
Looking to see if someone can help point me in the right direction
with
determining why my spreadsheet (VERY large with a lot of ranges,
variables)
is acting up. Up until recently the model worked perfect, recently I
added
some model protection and user sign-on requirements, but don't have
any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model
is
not
recalculating or updating the ranges after each use. The user
selects
a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and
so
on,
the value is assigned to a named range, which drives pivot tables,
the
coping
of other ranges and so on. While doing some debugging, I noticed
that
the
named ranges are keeping the previous value.

Thanks for any help

In outlook express

Tools Options Send Plain text settings

OE allows up to 132 chars... (default is 72)

********10********20********30********40********50 ********60********70******
**80********90*******100*******110*******120****** *130********

Tim

--
Tim Williams
Palo Alto, CA


"Bob Phillips" wrote in message
...
Hi Niek,

No, I just use the bog-standard reply mechanism (excuse my gutter
English).
I was hoping you had the solution, because we get so many problems with
wrap-around in code that it would solve.

Regards

Bob

"Niek Otten" wrote in message
...
Hi Bob,

I wish I knew!

It does here.
I've been struggling with template replies for some time now. If I use
Word, I get double spaced lines, maybe you don't?
If I paste to Excel and paste from there into OE, it looks fine here (of
course I tested a private reply first!)
Do you ever use pre-cooked replies and if so, how?

--
Kind regards,

Niek Otten

"Bob Phillips" wrote in message
...
Okay, Niek, spill the beans. Why didn't the text of your response get
truncated into short lines as does everyone else's? <G

Bob

"Niek Otten" wrote in message
...
My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened
unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened
determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance
of
Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells
directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation.
You
can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct
sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious
recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up.
One
way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing
CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message
...
Looking to see if someone can help point me in the right direction
with
determining why my spreadsheet (VERY large with a lot of ranges,
variables)
is acting up. Up until recently the model worked perfect, recently
I
added
some model protection and user sign-on requirements, but don't have
any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model
is
not
recalculating or updating the ranges after each use. The user
selects
a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and
so
on,
the value is assigned to a named range, which drives pivot tables,
the
coping
of other ranges and so on. While doing some debugging, I noticed
that
the
named ranges are keeping the previous value.

Thanks for any help

Yes, I have that set to 130
But if I reply to myself (my wife complains I do that all the time) I still get wraps where I don't want them.
I still don't know how to prevent VBA code from wrapping, apart from manually breaking at .... yes, at what?
Are other NGreaders better at this? And what about the poor receivers who still use OE?

--
Kind regards,

Niek Otten

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
| In outlook express
|
| Tools Options Send Plain text settings
|
| OE allows up to 132 chars... (default is 72)
|
| ********10********20********30********40********50 ********60********70******
| **80********90*******100*******110*******120****** *130********
|
| Tim
|
| --
| Tim Williams
| Palo Alto, CA
|
|
| "Bob Phillips" wrote in message
| ...
| Hi Niek,
|
| No, I just use the bog-standard reply mechanism (excuse my gutter
| English).
| I was hoping you had the solution, because we get so many problems with
| wrap-around in code that it would solve.
|
| Regards
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| Hi Bob,
|
| I wish I knew!
|
| It does here.
| I've been struggling with template replies for some time now. If I use
| Word, I get double spaced lines, maybe you don't?
| If I paste to Excel and paste from there into OE, it looks fine here (of
| course I tested a private reply first!)
| Do you ever use pre-cooked replies and if so, how?
|
| --
| Kind regards,
|
| Niek Otten
|
| "Bob Phillips" wrote in message
| ...
| Okay, Niek, spill the beans. Why didn't the text of your response get
| truncated into short lines as does everyone else's? <G
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| My standard list. Do look at 4 (don't skip the rest).
|
| --
| Kind regards,
|
| Niek Otten
|
|
| Cells not calculating (correctly)
|
| Most frequent causes:
|
| 1. Calculation is set to Automatic. This may have happened
| unintentionally, for example by opening another workbook first.
| Calculation is an Excel-wide setting; the first workbook opened
| determines the calculation mode, which then applies to all
| open workbooks and workbooks that are opened later in that instance
| of
| Excel. It can be changed manually (again, for all open
| workbooks):
| ToolsOptionsCalculation tab, check Automatic.
| 2. There are User Defined Functions (UDFs) which access cells
| directly from within the function, that is, not via the
| argument list. Then Excel is not aware of the need of recalculation.
| You
| can include Application.Volatile in the function, but
| there is no guarantee this will always calculate cells in the correct
| sequence in all (future) versions of Excel. Really the best
| way is to include all precedent cells in the argument list.
| 3. Excel version 5.0a (yes, very, very old!) has serious
| recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
| to calculate correctly.
| 4. Very, very rarely, Excel's dependency tree gets messed up.
| One
| way to rebuild it is to find and replace all "=" by "=",
| for all sheets. Later versions of Excel rebuild by pressing
| CTRL+ALT+SHIFT+F9
| 5. For many calculation secrets, visit Charles William's site:
| www.decisionmodels.com
|
|
| "Gardfd" wrote in message
| ...
| Looking to see if someone can help point me in the right direction
| with
| determining why my spreadsheet (VERY large with a lot of ranges,
| variables)
| is acting up. Up until recently the model worked perfect, recently
| I
| added
| some model protection and user sign-on requirements, but don't have
| any
| conflicts I'm can see.
|
| The issue: Some of my ranges are not updating, it's like the model
| is
| not
| recalculating or updating the ranges after each use. The user
| selects
| a
| state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and
| so
| on,
| the value is assigned to a named range, which drives pivot tables,
| the
| coping
| of other ranges and so on. While doing some debugging, I noticed
| that
| the
| named ranges are keeping the previous value.
|
| Thanks for any help
|
|
|
|
|
|
|
|
|
|
|

.... and even setting that didn't work for me (reading in OE). Still wraps at 70-something


--
Tim Williams
Palo Alto, CA


"Niek Otten" wrote in message ...
Yes, I have that set to 130
But if I reply to myself (my wife complains I do that all the time) I still get wraps where I don't want them.
I still don't know how to prevent VBA code from wrapping, apart from manually breaking at .... yes, at what?
Are other NGreaders better at this? And what about the poor receivers who still use OE?

--
Kind regards,

Niek Otten

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
| In outlook express
|
| Tools Options Send Plain text settings
|
| OE allows up to 132 chars... (default is 72)
|
| ********10********20********30********40********50 ********60********70******
| **80********90*******100*******110*******120****** *130********
|
| Tim
|
| --
| Tim Williams
| Palo Alto, CA
|
|
| "Bob Phillips" wrote in message
| ...
| Hi Niek,
|
| No, I just use the bog-standard reply mechanism (excuse my gutter
| English).
| I was hoping you had the solution, because we get so many problems with
| wrap-around in code that it would solve.
|
| Regards
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| Hi Bob,
|
| I wish I knew!
|
| It does here.
| I've been struggling with template replies for some time now. If I use
| Word, I get double spaced lines, maybe you don't?
| If I paste to Excel and paste from there into OE, it looks fine here (of
| course I tested a private reply first!)
| Do you ever use pre-cooked replies and if so, how?
|
| --
| Kind regards,
|
| Niek Otten
|
| "Bob Phillips" wrote in message
| ...
| Okay, Niek, spill the beans. Why didn't the text of your response get
| truncated into short lines as does everyone else's? <G
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| My standard list. Do look at 4 (don't skip the rest).
|
| --
| Kind regards,
|
| Niek Otten
|
|
| Cells not calculating (correctly)
|
| Most frequent causes:
|
| 1. Calculation is set to Automatic. This may have happened
| unintentionally, for example by opening another workbook first.
| Calculation is an Excel-wide setting; the first workbook opened
| determines the calculation mode, which then applies to all
| open workbooks and workbooks that are opened later in that instance
| of
| Excel. It can be changed manually (again, for all open
| workbooks):
| ToolsOptionsCalculation tab, check Automatic.
| 2. There are User Defined Functions (UDFs) which access cells
| directly from within the function, that is, not via the
| argument list. Then Excel is not aware of the need of recalculation.
| You
| can include Application.Volatile in the function, but
| there is no guarantee this will always calculate cells in the correct
| sequence in all (future) versions of Excel. Really the best
| way is to include all precedent cells in the argument list.
| 3. Excel version 5.0a (yes, very, very old!) has serious
| recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
| to calculate correctly.
| 4. Very, very rarely, Excel's dependency tree gets messed up.
| One
| way to rebuild it is to find and replace all "=" by "=",
| for all sheets. Later versions of Excel rebuild by pressing
| CTRL+ALT+SHIFT+F9
| 5. For many calculation secrets, visit Charles William's site:
| www.decisionmodels.com
|
|
| "Gardfd" wrote in message
| ...
| Looking to see if someone can help point me in the right direction
| with
| determining why my spreadsheet (VERY large with a lot of ranges,
| variables)
| is acting up. Up until recently the model worked perfect, recently
| I
| added
| some model protection and user sign-on requirements, but don't have
| any
| conflicts I'm can see.
|
| The issue: Some of my ranges are not updating, it's like the model
| is
| not
| recalculating or updating the ranges after each use. The user
| selects
| a
| state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and
| so
| on,
| the value is assigned to a named range, which drives pivot tables,
| the
| coping
| of other ranges and so on. While doing some debugging, I noticed
| that
| the
| named ranges are keeping the previous value.
|
| Thanks for any help
|
|
|
|
|
|
|
|
|
|
|

Hi Tim,
I am only familiar with my system running on a PC, know nothing
about MACs or even they use OE at all.

Did you set your plain text settings to 132 in BOTH
Tools, Options, Send, Mail: Plain Text 132
Tools, Options, Send, News: Plain Text 132
While there also make sure that the following is not checked
[ ] Reply to message using the format in which it was sent.

As far as you reading something, you are also dependent on what the
sender (both original poster and repliers) sent.. This all strictly OE,
and does not affect the reading.

Doubt that it would make a difference, but I am using 6.00.2800.1807
and I see you are using 6.00.2800.1506 suggest going to update
site to update (don't use, don't approve automatic update, as you won't know what is happening)
Microsoft Security Updates (Patch Tuesday is 2nd Tue each month)
http://www.microsoft.com/security/default.mspx

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
... and even setting that didn't work for me (reading in OE). Still wraps at 70-something


--
Tim Williams
Palo Alto, CA


"Niek Otten" wrote in message ...
Yes, I have that set to 130
But if I reply to myself (my wife complains I do that all the time) I still get wraps where I don't want them.
I still don't know how to prevent VBA code from wrapping, apart from manually breaking at .... yes, at what?
Are other NGreaders better at this? And what about the poor receivers who still use OE?

--
Kind regards,

Niek Otten

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
| In outlook express
|
| Tools Options Send Plain text settings
|
| OE allows up to 132 chars... (default is 72)
|
| ********10********20********30********40********50 ********60********70******
| **80********90*******100*******110*******120****** *130********
|
| Tim
|
| --
| Tim Williams
| Palo Alto, CA
|
|
| "Bob Phillips" wrote in message
| ...
| Hi Niek,
|
| No, I just use the bog-standard reply mechanism (excuse my gutter
| English).
| I was hoping you had the solution, because we get so many problems with
| wrap-around in code that it would solve.
|
| Regards
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| Hi Bob,
|
| I wish I knew!
|
| It does here.
| I've been struggling with template replies for some time now. If I use
| Word, I get double spaced lines, maybe you don't?
| If I paste to Excel and paste from there into OE, it looks fine here (of
| course I tested a private reply first!)
| Do you ever use pre-cooked replies and if so, how?
|
| --
| Kind regards,
|
| Niek Otten
|
| "Bob Phillips" wrote in message
| ...
| Okay, Niek, spill the beans. Why didn't the text of your response get
| truncated into short lines as does everyone else's? <G
|
| Bob
|
| "Niek Otten" wrote in message
| ...
| My standard list. Do look at 4 (don't skip the rest).
|
| --
| Kind regards,
|
| Niek Otten
|
|
| Cells not calculating (correctly)
|
| Most frequent causes:
|
| 1. Calculation is set to Automatic. This may have happened
| unintentionally, for example by opening another workbook first.
| Calculation is an Excel-wide setting; the first workbook opened
| determines the calculation mode, which then applies to all
| open workbooks and workbooks that are opened later in that instance
| of
| Excel. It can be changed manually (again, for all open
| workbooks):
| ToolsOptionsCalculation tab, check Automatic.
| 2. There are User Defined Functions (UDFs) which access cells
| directly from within the function, that is, not via the
| argument list. Then Excel is not aware of the need of recalculation.
| You
| can include Application.Volatile in the function, but
| there is no guarantee this will always calculate cells in the correct
| sequence in all (future) versions of Excel. Really the best
| way is to include all precedent cells in the argument list.
| 3. Excel version 5.0a (yes, very, very old!) has serious
| recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
| to calculate correctly.
| 4. Very, very rarely, Excel's dependency tree gets messed up.
| One
| way to rebuild it is to find and replace all "=" by "=",
| for all sheets. Later versions of Excel rebuild by pressing
| CTRL+ALT+SHIFT+F9
| 5. For many calculation secrets, visit Charles William's site:
| www.decisionmodels.com
|
|
| "Gardfd" wrote in message
| ...
| Looking to see if someone can help point me in the right direction
| with
| determining why my spreadsheet (VERY large with a lot of ranges,
| variables)
| is acting up. Up until recently the model worked perfect, recently
| I
| added
| some model protection and user sign-on requirements, but don't have
| any
| conflicts I'm can see.
|
| The issue: Some of my ranges are not updating, it's like the model
| is
| not
| recalculating or updating the ranges after each use. The user
| selects
| a
| state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and
| so
| on,
| the value is assigned to a named range, which drives pivot tables,
| the
| coping
| of other ranges and so on. While doing some debugging, I noticed
| that
| the
| named ranges are keeping the previous value.
|
| Thanks for any help
|
|
|
|
|
|
|
|
|
|
|

Thanks David.

I'll try some things out over in the *.test group.

Tim

"David McRitchie" wrote in message ...
Hi Tim,
I am only familiar with my system running on a PC, know nothing
about MACs or even they use OE at all.

Did you set your plain text settings to 132 in BOTH
Tools, Options, Send, Mail: Plain Text 132
Tools, Options, Send, News: Plain Text 132
While there also make sure that the following is not checked
[ ] Reply to message using the format in which it was sent.

As far as you reading something, you are also dependent on what the
sender (both original poster and repliers) sent.. This all strictly OE,
and does not affect the reading.

Doubt that it would make a difference, but I am using 6.00.2800.1807
and I see you are using 6.00.2800.1506 suggest going to update
site to update (don't use, don't approve automatic update, as you won't know what is happening)
Microsoft Security Updates (Patch Tuesday is 2nd Tue each month)
http://www.microsoft.com/security/default.mspx

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
... and even setting that didn't work for me (reading in OE). Still wraps at 70-something


--
Tim Williams
Palo Alto, CA


"Niek Otten" wrote in message ...
Yes, I have that set to 130
But if I reply to myself (my wife complains I do that all the time) I still get wraps where I don't want them.
I still don't know how to prevent VBA code from wrapping, apart from manually breaking at .... yes, at what?
Are other NGreaders better at this? And what about the poor receivers who still use OE?

--
Kind regards,

Niek Otten

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
| In outlook express
|
| Tools Options Send Plain text settings
|
| OE allows up to 132 chars... (default is 72)
|
| ********10********20********30********40********50 ********60********70******
| **80********90*******100*******110*******120****** *130********
|
| Tim
|
| --
| Tim Williams
| Palo Alto, CA