Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options saved with the worksheet?
Under tools/options, are the options saved with the worksheet, or do they
apply across-the-board for all files that the user is working on? If I set an option and send the file to someone else, who may have different options set, which option settings are used when the recipient opens the file? I'm particularly interested in the options on the Edit tab, but I'd like to know how this works in general. (In MS Word, some options stay with the file while others stay with the user. It can be very confusing!) Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options saved with the worksheet?
Different options have different scopes. But all of the Edit options are
user-level. That means they are saved in the registry when the user closes Excel and restored when it is restarted. Ergo, none of the Edit options are saved with the workbook. -- Jim "Eric" wrote in message ... | Under tools/options, are the options saved with the worksheet, or do they | apply across-the-board for all files that the user is working on? If I set | an option and send the file to someone else, who may have different options | set, which option settings are used when the recipient opens the file? | | I'm particularly interested in the options on the Edit tab, but I'd like to | know how this works in general. | | (In MS Word, some options stay with the file while others stay with the | user. It can be very confusing!) | | Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options saved with the worksheet?
Thanks. Do you know if the scope of the options is documented anywhere?
"Jim Rech" wrote: Different options have different scopes. But all of the Edit options are user-level. That means they are saved in the registry when the user closes Excel and restored when it is restarted. Ergo, none of the Edit options are saved with the workbook. -- Jim "Eric" wrote in message ... | Under tools/options, are the options saved with the worksheet, or do they | apply across-the-board for all files that the user is working on? If I set | an option and send the file to someone else, who may have different options | set, which option settings are used when the recipient opens the file? | | I'm particularly interested in the options on the Edit tab, but I'd like to | know how this works in general. | | (In MS Word, some options stay with the file while others stay with the | user. It can be very confusing!) | | Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options saved with the worksheet?
No I don't. I did my own 'documentation' several years ago and I referred
to it to answer your question. It doesn't have any authority of course but if you want a copy send me an email. -- Jim "Eric" wrote in message ... | Thanks. Do you know if the scope of the options is documented anywhere? | | "Jim Rech" wrote: | | Different options have different scopes. But all of the Edit options are | user-level. That means they are saved in the registry when the user closes | Excel and restored when it is restarted. Ergo, none of the Edit options are | saved with the workbook. | | -- | Jim | "Eric" wrote in message | ... | | Under tools/options, are the options saved with the worksheet, or do they | | apply across-the-board for all files that the user is working on? If I | set | | an option and send the file to someone else, who may have different | options | | set, which option settings are used when the recipient opens the file? | | | | I'm particularly interested in the options on the Edit tab, but I'd like | to | | know how this works in general. | | | | (In MS Word, some options stay with the file while others stay with the | | user. It can be very confusing!) | | | | Thanks. | | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options saved with the worksheet?
Can we clarify this statement RE 2007, as I am having trouble with the prompt
to update links (when opening a file). Have 2007 settings as; no automatic update, ask to update automatic links and have tried various combinations of let the user choose, however, not being prompted. This is an issue as macro link error messages are being returned when files are converted from 2003 to 2007. Example, still using unchanges 2003 code "UpdateLinks:=3, ReadOnly:=False, IgnoreReadOnlyRecommended:=True" This could also be a problem with network security of the excel 2007 installation, if so what do I tell IT as far as a location to allow? Thank you, John "Jim Rech" wrote: Different options have different scopes. But all of the Edit options are user-level. That means they are saved in the registry when the user closes Excel and restored when it is restarted. Ergo, none of the Edit options are saved with the workbook. -- Jim "Eric" wrote in message ... | Under tools/options, are the options saved with the worksheet, or do they | apply across-the-board for all files that the user is working on? If I set | an option and send the file to someone else, who may have different options | set, which option settings are used when the recipient opens the file? | | I'm particularly interested in the options on the Edit tab, but I'd like to | know how this works in general. | | (In MS Word, some options stay with the file while others stay with the | user. It can be very confusing!) | | Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
can not imput data on saved worksheet | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions |