ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating Excel Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/258578-updating-excel-spreadsheet.html)

joesw

Updating Excel Spreadsheet
 
I have 3 users that use the same spreadsheet, is there a way of automatically
updating the spreadsheet of one user with newer information input by another
user.

Milan Bortel

Updating Excel Spreadsheet
 
Hello,

I think you should use shared workbook.

Ex2003: Tools/Share Workbook...

Ex2007: Review Ribbon/Share Workbook...

Obviously, you need to save the file into shared drive.

Let us know if it works :)

--
Milan Bortel

MCP, MCAS, MCTS
GOPAS Computer Training Center
Brno, Czech Republic


"joesw" wrote:

I have 3 users that use the same spreadsheet, is there a way of automatically
updating the spreadsheet of one user with newer information input by another
user.



All times are GMT +1. The time now is 07:43 AM.

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