Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook save options
Hi,
I've got a workbook saved on the network folder . I'd like people to be able to make changes in this file and save the changes as well. However , what I'd like to do, is prevent a user from saving their copy over this orginal copy . So basically they can only make changes in the original file, but cannot overwrite the original file with one of their workbooks . Is this possible ? Thanks for any help . Rgds KM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook save options
Hi KM,
Find your file on the server. RightClick its icon, then select Properties. On the General tab tick Read Only Click ok Regards - Dave. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook save options
Hi Dave,
Thanks for your answer. Sorry, couldn't reply earlier. Making it a "read-only" was my initial thought process , but wouldn't that stop people from making changes within the file as well ? I'd still like them to make changes within this file, just not be able to save one of their files with the same file name as my report . Sorry, if that doesn't sound very clear . KM "Dave" wrote: Hi KM, Find your file on the server. RightClick its icon, then select Properties. On the General tab tick Read Only Click ok Regards - Dave. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook save options
Hi KM,
Sorry, don't have a solution for that - except back-up regularly, and perhaps call your file by a name that no one else is likely to use. Perhaps qwerty12345.xls or similar. Regards - Dave |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook save options
Hi Dave,
Look, thanks anyway your help . I guess I'll just have to trust the people using the file not to muck around with it...:) Rgds KM "Dave" wrote: Hi KM, Sorry, don't have a solution for that - except back-up regularly, and perhaps call your file by a name that no one else is likely to use. Perhaps qwerty12345.xls or similar. Regards - Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
Save options | Excel Discussion (Misc queries) | |||
Save options | New Users to Excel | |||
How do I set Save Options? | Excel Discussion (Misc queries) | |||
How can I save an other route in my Tools bar-options-save? IT | Excel Discussion (Misc queries) |