Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
Apart from Excel Web App and sharing on network, how can we share a file with multiple users.
For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
Abhijeet Gudur wrote:
Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote:
Abhijeet Gudur wrote: Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database Thanks for your response. Trying Excel(front end) + DB. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
Abhijeet Gudur wrote:
On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote: Abhijeet Gudur wrote: Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database Thanks for your response. Trying Excel(front end) + DB. it works if you do not have concurrent users trying modification of the same data at the same time. Unless you know how to play with record locking in access. For read only/ view only, especially when data goes to excel table or pivot table which can be automatically refreshed that can be the easiest thing to do. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
On Thursday, 30 January 2014 09:16:27 UTC+5:30, witek wrote:
Abhijeet Gudur wrote: On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote: Abhijeet Gudur wrote: Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database Thanks for your response. Trying Excel(front end) + DB. it works if you do not have concurrent users trying modification of the same data at the same time. Unless you know how to play with record locking in access. For read only/ view only, especially when data goes to excel table or pivot table which can be automatically refreshed that can be the easiest thing to do. Thanks for your thoughts.They are right and mutual.Team of five will access the DB through excel file(macro to get and send updates).Restricting access at excel level, one user cannot see data of another user. So even if they send update to DB it will update just their records. And yes, they will not be accessing at once since they work in different shifts/Time zones. Am I missing something ?? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
Abhijeet Gudur wrote:
On Thursday, 30 January 2014 09:16:27 UTC+5:30, witek wrote: Abhijeet Gudur wrote: On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote: Abhijeet Gudur wrote: Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database Thanks for your response. Trying Excel(front end) + DB. it works if you do not have concurrent users trying modification of the same data at the same time. Unless you know how to play with record locking in access. For read only/ view only, especially when data goes to excel table or pivot table which can be automatically refreshed that can be the easiest thing to do. Thanks for your thoughts.They are right and mutual.Team of five will access the DB through excel file(macro to get and send updates).Restricting access at excel level, one user cannot see data of another user. So even if they send update to DB it will update just their records. And yes, they will not be accessing at once since they work in different shifts/Time zones. Am I missing something ?? it should work as long as they do not try update the same data. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sharing
On Friday, 31 January 2014 22:00:38 UTC+5:30, witek wrote:
Abhijeet Gudur wrote: On Thursday, 30 January 2014 09:16:27 UTC+5:30, witek wrote: Abhijeet Gudur wrote: On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote: Abhijeet Gudur wrote: Apart from Excel Web App and sharing on network, how can we share a file with multiple users. For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month. Please suggest other options. Thanks. website + database Thanks for your response. Trying Excel(front end) + DB. it works if you do not have concurrent users trying modification of the same data at the same time. Unless you know how to play with record locking in access. For read only/ view only, especially when data goes to excel table or pivot table which can be automatically refreshed that can be the easiest thing to do. Thanks for your thoughts.They are right and mutual.Team of five will access the DB through excel file(macro to get and send updates).Restricting access at excel level, one user cannot see data of another user. So even if they send update to DB it will update just their records. And yes, they will not be accessing at once since they work in different shifts/Time zones. Am I missing something ?? it should work as long as they do not try update the same data. Cheers! happy weekend. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file sharing | Excel Discussion (Misc queries) | |||
file sharing | Excel Programming | |||
File sharing | Excel Discussion (Misc queries) | |||
File Sharing | Setting up and Configuration of Excel | |||
FILE SHARING | Excel Worksheet Functions |