XL2003: Which settings are session-wide, which are per wkbk?

[Ed]

I know some settings, like Calculation, are set for the current
session of Excel, and can't be different for individual workbooks
during the same application instance. Are they all like that? Or are
there some which can be set for one workbook which will not affect
other workbooks during the same session? Does a list exist somewhere
that gives this info? I'm most interested in:

Show gridlines
Show zero values
Move selection after enter
Enable Autocomplete
Extend data range
Sheets in new workbook
Error checking and rules
Smart tag settings

Ed

 

[Roger Govier]

Hi Jim

Thank you for that.
I will try and test each fro XL2007 when I have the chance - but don't
hold your breath<bg>

 

[Jim Rech]

Yeah, I'm not too eager to update it either. Maybe someday...<g>

--
Jim
| Hi Jim
|
| Thank you for that.
| I will try and test each fro XL2007 when I have the chance - but don't
| hold your breath<bg>
|
| --
| Regards
|
| Roger Govier
|
|
| | > Well, I did a list, which I attach and happily donate to the group.
| > Of
| > course it has no authority but I've referred to it many times over the
| > years
| > and I believe it's pretty accurate. For versions 97-2003, not updated
| > for
| > Excel 2007.
| >
| > --
| > Jim
| > | > |I know some settings, like Calculation, are set for the current
| > | session of Excel, and can't be different for individual workbooks
| > | during the same application instance. Are they all like that? Or
| > are
| > | there some which can be set for one workbook which will not affect
| > | other workbooks during the same session? Does a list exist
| > somewhere
| > | that gives this info? I'm most interested in:
| > |
| > | Show gridlines
| > | Show zero values
| > | Move selection after enter
| > | Enable Autocomplete
| > | Extend data range
| > | Sheets in new workbook
| > | Error checking and rules
| > | Smart tag settings
| > |
| > | Ed
| > |
| >
| >
| >
|
|

 

[Ed]

Jim and Roger:

|| > Well, I did a list, which I attach and happily donate to the group.

I don't know what happened, but Jim's post with the list doesn't show
up for me through Google Groups.
Is there another way to find it?

Ed

 

[Peo Sjoblom]

Send an email to (e-mail address removed)

remove the X

and I'll email it to you

 

[Ed]

Peo:

I got it. Thank you.


Jim:

That looks like a lot of work! Thanks for sharing your hard efforts
with us.

Ed