Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
I have a workbook on a network drive that more than 1 person uses. If the
workbook is open to more than 1 person at the same time, how can it be updated in real-time so that each can see what has been input? Also how can I get round having to save it under a different name? If one exits excel then the prompt is to save, but when you do, it requests that it is saved with a different name. What is worrying is that it is updated, the last person saves, but the other persons data isn't. One file becomes read only. Any suggestions please. Bryan. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Is it a shared workbook? have you set up whose changes get saved?, if its not a shared workbook then the person who opens the workbook after it has been opened will get the message "Locked for editing, Open Read Only?" -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=40148 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Simon,
Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? "Simon Lloyd" wrote in message ... Is it a shared workbook? have you set up whose changes get saved?, if its not a shared workbook then the person who opens the workbook after it has been opened will get the message "Locked for editing, Open Read Only?" -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=40148 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Bryan De-Lara wrote:
Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Thanks Glenn, I did, I need to try it out now.
Bryan. "Glenn" wrote in message ... Bryan De-Lara wrote: Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
When in help "about shared workbooks" also take note of the loss of
functionality in shared workbooks. Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 17:00:48 -0000, "Bryan De-Lara" wrote: Thanks Glenn, I did, I need to try it out now. Bryan. "Glenn" wrote in message ... Bryan De-Lara wrote: Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Thanks Gord, is there any other way so that functionality is the same?
Bryan. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... When in help "about shared workbooks" also take note of the loss of functionality in shared workbooks. Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 17:00:48 -0000, "Bryan De-Lara" wrote: Thanks Glenn, I did, I need to try it out now. Bryan. "Glenn" wrote in message .. . Bryan De-Lara wrote: Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
In view of your original question about multiple users working on the same
workbook simultaneously, I can see no other option than to share the workbook. Gord On Sat, 13 Dec 2008 11:54:37 -0000, "Bryan De-Lara" wrote: Thanks Gord, is there any other way so that functionality is the same? Bryan. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . When in help "about shared workbooks" also take note of the loss of functionality in shared workbooks. Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 17:00:48 -0000, "Bryan De-Lara" wrote: Thanks Glenn, I did, I need to try it out now. Bryan. "Glenn" wrote in message . .. Bryan De-Lara wrote: Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's one for the techies unless a macro will do it.
Thanks Gord.
This thread is now closed. Bryan. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... In view of your original question about multiple users working on the same workbook simultaneously, I can see no other option than to share the workbook. Gord On Sat, 13 Dec 2008 11:54:37 -0000, "Bryan De-Lara" wrote: Thanks Gord, is there any other way so that functionality is the same? Bryan. "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. When in help "about shared workbooks" also take note of the loss of functionality in shared workbooks. Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 17:00:48 -0000, "Bryan De-Lara" wrote: Thanks Glenn, I did, I need to try it out now. Bryan. "Glenn" wrote in message .. . Bryan De-Lara wrote: Simon, Thanks Simon, Everyone who opens it will make changes and it all should be saved. How do I set it up as a shared workbook? You could try "About shared workbooks" in the help file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |