MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MOSS 2007 - Multiple users accessing an excel file

  Date: Sep 24    Category: MOSS    Views: 634

I have some Excel 2003 files in a document library.

I would like to find out how I can set it up so multiple users can all
access the file at the same time.

At present we have staff checking in and checking out the file, but I
would prefer multiple access to the same file

Is this possible with Excel 2003 file and a SP MOSS 2007 site?



3 Answers Found

Answer #1    Answered On: Sep 24    

Have you looked into Excel Services (assuming you have that available on
your farm)? I'm not sure if it'll give you everything you need (especially
in 2007), but it's worth a check.

Answer #2    Answered On: Sep 24    

If the Excel spreadsheets are simply used

* Used to store and view information as rows in a spreadsheet

* Do not use macros etc...

Consider "migrating" and replacing each spreadsheet with a SharePoint list

* will let you store and view information as items in the list

* will allow multiple people to edit different items - at the same time

* you can create list views to meet specific needs

* as a one-off migration step you can import the existing spreadsheet into the list

Answer #3    Answered On: Sep 24    
Didn't find what you were looking for? Find more on MOSS 2007 - Multiple users accessing an excel file Or get search suggestion and latest updates.