PC Review


Reply
Thread Tools Rate Thread

HOW TO CREATE A REAL SHARED XLS ?

 
 
Disperso
Guest
Posts: n/a
 
      23rd Aug 2004
i want to create a xls file that more user can modify contemporarily.
i want that if an user change a cell, other user see realtime the cell to
change ....is possible ?




 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      23rd Aug 2004
Not realtime.

Under Tools|Share workbook|Advanced Tab, you can see your options.

And if you look at Excel's help (this is from xl2002):

Seeing other users' changes Each time you save the shared workbook, you're
updated with any changes that others have saved since the last time you saved.
If you want to keep the shared workbook open to monitor progress, you can have
Microsoft Excel update you with changes automatically, at timed intervals that
you specify, with or without saving the workbook yourself.

Disperso wrote:
>
> i want to create a xls file that more user can modify contemporarily.
> i want that if an user change a cell, other user see realtime the cell to
> change ....is possible ?


--

Dave Peterson
(E-Mail Removed)
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      23rd Aug 2004
And be aware that there are a lot of features that don't work with shared
workbooks (also described in Excel's help).



Disperso wrote:
>
> i want to create a xls file that more user can modify contemporarily.
> i want that if an user change a cell, other user see realtime the cell to
> change ....is possible ?


--

Dave Peterson
(E-Mail Removed)
 
Reply With Quote
 
Disperso
Guest
Posts: n/a
 
      30th Aug 2004
i see that autosave function is minimum 1 minute ...this is the maximum
realtime ?

"Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> And be aware that there are a lot of features that don't work with shared
> workbooks (also described in Excel's help).
>
>
>
> Disperso wrote:
> >
> > i want to create a xls file that more user can modify contemporarily.
> > i want that if an user change a cell, other user see realtime the cell

to
> > change ....is possible ?

>
> --
>
> Dave Peterson
> (E-Mail Removed)



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      30th Aug 2004
Minimum realtime???

I don't use autosave, but IIRC, it only uses minutes in that dialog.



Disperso wrote:
>
> i see that autosave function is minimum 1 minute ...this is the maximum
> realtime ?
>
> "Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
> news:(E-Mail Removed)...
> > And be aware that there are a lot of features that don't work with shared
> > workbooks (also described in Excel's help).
> >
> >
> >
> > Disperso wrote:
> > >
> > > i want to create a xls file that more user can modify contemporarily.
> > > i want that if an user change a cell, other user see realtime the cell

> to
> > > change ....is possible ?

> >
> > --
> >
> > Dave Peterson
> > (E-Mail Removed)


--

Dave Peterson
(E-Mail Removed)
 
Reply With Quote
 
Disperso
Guest
Posts: n/a
 
      31st Aug 2004
no autosave ?!
what's IIRC ?

"Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> Minimum realtime???
>
> I don't use autosave, but IIRC, it only uses minutes in that dialog.
>
>
>
> Disperso wrote:
> >
> > i see that autosave function is minimum 1 minute ...this is the maximum
> > realtime ?
> >
> > "Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
> > news:(E-Mail Removed)...
> > > And be aware that there are a lot of features that don't work with

shared
> > > workbooks (also described in Excel's help).
> > >
> > >
> > >
> > > Disperso wrote:
> > > >
> > > > i want to create a xls file that more user can modify

contemporarily.
> > > > i want that if an user change a cell, other user see realtime the

cell
> > to
> > > > change ....is possible ?
> > >
> > > --
> > >
> > > Dave Peterson
> > > (E-Mail Removed)

>
> --
>
> Dave Peterson
> (E-Mail Removed)



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      31st Aug 2004
One thing I don't like about autosave is that it destroys the undo stack.

I save often--but only when I want to.

IIRC is an acronym for "If I Recall Correctly"



Disperso wrote:
>
> no autosave ?!
> what's IIRC ?
>
> "Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
> news:(E-Mail Removed)...
> > Minimum realtime???
> >
> > I don't use autosave, but IIRC, it only uses minutes in that dialog.
> >
> >
> >
> > Disperso wrote:
> > >
> > > i see that autosave function is minimum 1 minute ...this is the maximum
> > > realtime ?
> > >
> > > "Dave Peterson" <(E-Mail Removed)> ha scritto nel messaggio
> > > news:(E-Mail Removed)...
> > > > And be aware that there are a lot of features that don't work with

> shared
> > > > workbooks (also described in Excel's help).
> > > >
> > > >
> > > >
> > > > Disperso wrote:
> > > > >
> > > > > i want to create a xls file that more user can modify

> contemporarily.
> > > > > i want that if an user change a cell, other user see realtime the

> cell
> > > to
> > > > > change ....is possible ?
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > > (E-Mail Removed)

> >
> > --
> >
> > Dave Peterson
> > (E-Mail Removed)


--

Dave Peterson
(E-Mail Removed)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
shared workbook locked for no real reason Aram Microsoft Excel Crashes 0 1st May 2008 07:07 PM
Is there anyone has real time to create a DVD photo slideshow? alabama_wolfs Windows XP Photos 2 12th Jul 2006 02:48 AM
real easy help - no server cannot create ASP.NET Robbe Morris [C# MVP] Microsoft ASP .NET 4 3rd Jan 2006 12:52 AM
Create Real Lines =?Utf-8?B?ZmxhbWVzdGFy?= Microsoft Word Document Management 10 31st Jul 2005 06:59 PM
Create a printjob (but real slow) Sleurhutje Microsoft Windows 2000 Printing 0 15th Sep 2003 08:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 AM.