linking workbooks
I need help linking a workbook that I use daily. I want my co-workers to be
able to access it on our shared server. I want to be able to make changes to myworkbook and it automatically save in the copy on the shared server. I also don't want them to be able to change anything. I tried to password protect each sheet, but they could not use the filter function. They need to be able to sort and auto filter but not save changes. Can you help me. I have tried several things nothing works like I need it to. Saving as a Web Page didn't help either. Thank you. |
Try:
FileSave As...on the toolbar select ToolsGeneral Options and use a password to modify. This should work. "susie" wrote: I need help linking a workbook that I use daily. I want my co-workers to be able to access it on our shared server. I want to be able to make changes to myworkbook and it automatically save in the copy on the shared server. I also don't want them to be able to change anything. I tried to password protect each sheet, but they could not use the filter function. They need to be able to sort and auto filter but not save changes. Can you help me. I have tried several things nothing works like I need it to. Saving as a Web Page didn't help either. Thank you. |
Thank you for the help. I will try that "StinkeyPete" wrote: Try: FileSave As...on the toolbar select ToolsGeneral Options and use a password to modify. This should work. "susie" wrote: I need help linking a workbook that I use daily. I want my co-workers to be able to access it on our shared server. I want to be able to make changes to myworkbook and it automatically save in the copy on the shared server. I also don't want them to be able to change anything. I tried to password protect each sheet, but they could not use the filter function. They need to be able to sort and auto filter but not save changes. Can you help me. I have tried several things nothing works like I need it to. Saving as a Web Page didn't help either. Thank you. |
All times are GMT +1. The time now is 03:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com