Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set excel files to be accessible by everyone and updated
I want to make this file to be accessible and can be updated by anyone. This
file is a database that everyone can add any information on it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set excel files to be accessible by everyone and updated
You could store the file on a common server that everyone has access to.
Then each person can update it as soon as the previous person is done (saved and closed). If you need to have simultaneous updates, then you could share the workbook (tools|Share workbook). But there are a lot of things that won't work in shared workbooks--check Excel's help for more info. And there are lots of people that won't use shared workbooks--many believe that it's just not worth the trouble (and risk--there are lots of posts about problems with shared workbooks--from corruption to just not even working as intended.) You may want to consider using a real database program (Access??) that is designed for this kind of shared environment. Askara_thea wrote: I want to make this file to be accessible and can be updated by anyone. This file is a database that everyone can add any information on it. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set excel files to be accessible by everyone and updated
Google spreadsheets might be what you want to
have many users updating as a group project. As a spreadsheet it's not that good but for your type of use it might work better for you. http://www.google.com/intl/en/options/ Of course you've not given any idea of how many people, the size of the worksheet. If you have privacy concerns then this would not be a viable solution. My own brief encounter with Excel shared workbooks can be summarized as how to unshare the workbook without having to restore from a backup. Tools -- Share Workbook -- uncheck option Highlight, Change Highlighting http://www.mvps.org/dmcritchie/excel/highlite.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Peterson" wrote in message ... You could store the file on a common server that everyone has access to. Then each person can update it as soon as the previous person is done (saved and closed). If you need to have simultaneous updates, then you could share the workbook (tools|Share workbook). But there are a lot of things that won't work in shared workbooks--check Excel's help for more info. And there are lots of people that won't use shared workbooks--many believe that it's just not worth the trouble (and risk--there are lots of posts about problems with shared workbooks--from corruption to just not even working as intended.) You may want to consider using a real database program (Access??) that is designed for this kind of shared environment. Askara_thea wrote: I want to make this file to be accessible and can be updated by anyone. This file is a database that everyone can add any information on it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: save updated files to F:\ | Excel Discussion (Misc queries) | |||
Updating or merging files, same file, they were updated independan | Excel Discussion (Misc queries) | |||
Making Excel accessible on our server | Excel Discussion (Misc queries) | |||
I want to share an excel workbook but the tab is not accessible | Excel Discussion (Misc queries) | |||
Excel updated with links in between destination files! | Links and Linking in Excel |