ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   To make the excel file in shared folder to be editable by every us (https://www.excelbanter.com/excel-worksheet-functions/202321-make-excel-file-shared-folder-editable-every-us.html)

Shefu

To make the excel file in shared folder to be editable by every us
 
There is an excel file in shared folder and every day its need to be updated
by every user.But the problem occurs when everyone try to access it at same
time to update and unable to do so as only one user can open and can make the
changes and save it.Its take much time to update the sheet.
Could you please help me regarding the same by telling any process to make
it editable by more than one user and get it saved simultaneously and any way
to come out of the problem?

Ashish Mathur[_2_]

To make the excel file in shared folder to be editable by every us
 
Hi,

Try using Tools Share workbook

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Shefu" wrote in message
...
There is an excel file in shared folder and every day its need to be
updated
by every user.But the problem occurs when everyone try to access it at
same
time to update and unable to do so as only one user can open and can make
the
changes and save it.Its take much time to update the sheet.
Could you please help me regarding the same by telling any process to make
it editable by more than one user and get it saved simultaneously and any
way
to come out of the problem?




All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com