Re: Shared Excel File

Tech-Archive recommends: Fix windows errors by optimizing your registry

I was assuming a "normal" Excel file.

The original poster said nothing about linked xls are any other
complication.

Engelbert

"Jonathan Davey" <me@xxxxxxxxxxxxxxx> wrote in message
news:O4OuJQFdGHA.5116@xxxxxxxxxxxxxxxxxxxxxxx
What about linked xls? What if more than 1 user creates a linked xls file
on their pc, how are changes handled and merged (excluding changes to same
fields for this exercise/query).

Example: User 1 and User 2 both create linked xls files. Both users close
xls. User 1 adds new rows within the exsiting columns within his local xls
file. User 1 "syncs" the local xls with SP and closes his xls file. User
2 opens his local xls, his copy does not contain the new rows. He "syncs"
the xls file....... presumably the new rows will be added? Or will the
omission of the rows in User 2's xls wipe the rows from SP?



"Engelbert" <Engelbert@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23ansChEdGHA.4932@xxxxxxxxxxxxxxxxxxxxxxx
The best way is to create a WSS List from that Excel file (a standard
function in the WSS UI when choosing Create) and then have users access
and amend that.

They could then for instance amend different rows at the same time with
no conflicts.

(There are many more usability functions too)

Engelbert

"David Harris" <DavidHarris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1AA0F07F-75DD-44AB-AEA2-E1A258445EC5@xxxxxxxxxxxxxxxx
We have Windows 2003 Server with Windows Sharepoint Services installed.

The Clients all have Windows Xp Pro SP2 and Office 2003 Professional.

We have a Excel file that needs to be accessible to several users and
they
need to be able to open it up at the same time and edit it.
Is this possible in Sharepoint? and if so how do I configure it?






.

Relevant Pages

  • Re: HTML / Excel format problem
    ... form selection I set the meta tag MIME type to HTML or XLS mode. ... If the user chooses XLS (and I add the MIME type header), ... Firstly I would like to clarify the scenario with you. ... Do you mean you want to Export an Excel file in an asp page? ...
    (microsoft.public.excel.programming)
  • Re: Sql Query: 255 character Limit
    ... In this case you may find that using both SQLStatement and SQLStatement1 ... in addition to the .xls you need for other purposes ... > Excel file with the ... > These are based to OpenDataSource() as ref'd objects. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Import an Excel file saved as text
    ... Open the ".xls" file with Notepad. ... becuase it's breaking the rules by giving it a .xls extension. ... They are saved as an Excel file with the .xls extension. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: Writing to Excel File via OleDB
    ... Does the ASP.NET app running user account (ASPNET,NETWORK SERVICE, or ... whatever account you impersonated to) has the write permission to the "*.xls ... I'm trying to write to an Excel file via an OleDbConnection. ... but writing fails. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Shared Excel File
    ... we have an Excel file which has 3-4 worksheets. ... What I want to know is if this is possible with Sharepoint and what the best ... The original post WAS about sharing XLS files. ... User 1 "syncs" the local xls with SP and closes his xls ...
    (microsoft.public.sharepoint.windowsservices)